I would like to import receive money transactions from a csv. I have rent receipts that are net of agents commission and I want to import money received as gross rent and a negative money received as a commission expense. I don’t need to create a bank transaction as I already have a bank feed.

10 Feb 2022

You can do the work by following the below steps:

1. As your bank feeds are on so when the transactions appear for reconciliation you can add another line item showing the commission amount at the same time.

For example: If you have a say 100 rupees as gross rent, 2 as commission and 98 as net receipts. Thus whie reconciling the accounts show two line item i.e Gross rent as 100 and Commission as -2 on the reconciliation tab.

This will help you record gross rent and commission at the same time.

This is not achievabe through a CSV template but we have an inbuilt tool for importing the same through the template.

We are a migrating company and highest reviewed partner with XERO and provide data migration services so we can help you regarding the same.

For any further help, feel free to reach out on info@mmcconvert.com. For a quick discussion we can even connect for a zoom call.