I have some loans in Xero and to get the feeds to come through they are set up as bank accounts in Xero. When I "import the assumptions" it "wants" to go to the Cash section. If I map it to the "Debt" section it imports it as a negative number and unbalances the balance sheet. Does anyone know how to reverse the nature of an account on import or do I just have to amend it after I import?
I've amended the reporting codes in Xero but this didn't help.
Hi Tim,
You should be able to select the loan account in the balance sheet within the mapping tool and click the minus (-) key to subtract the data when importing, as shown below.
In my example this causes the data to un-reconcile, but in yours it should cause it to reconcile.
Further to Mike's post, and definitely don't want to add confusion, but purely a neat trick that I recently just realised.
You can bulk select categories on the destination side and just keyboard press "-", it will bulk flip signs. Amazingly useful!
Jun
worked like a charm! Thanks guys.