Hi,
I have an issue where i would like to be able to split a bank feed transaction between an income and expense account.
Instance is, where a deposit comes from a Merchant provider, that proivder only deposits the net amount to me. Therefore, it would be handy if i could split the transaction so that i can show the Gross amount to my sales account and the associated charges to the merchant fees expense. I note that both of these are subject to GST, so need the income to be able to be shown at G1 (Gross Sales) and 1A (GST on Sales) on the BAS report, and for the merchant Fees, G11 (Non Capital Purchases) and 1B (GST on Payments) for the purposes of the BAS.
Obviosuly this then shows the trasnaction being technically correct, as it is matching the income and expense by showing the two allocations that the one transaction relates to.
I note that there is software that can handle these sorts of splits of an income and expense in the one transaction, in particular Microsoft Dynamics NAV does this well.
Look forward to hearing from someone.
I also have this problem very regularly as I have many clients receiving rental income from agents where I need to split between the gross income and expenses to get to the net amount received. I note we cannot enter an amount higher than the net amount received and enter expenses as a negative amount. I agree with AccountsOnline as many clients on this software for me have moved from Banklink as an upgrade but it's really frustrating losing these functions.
Related Content
- 11 months ago
- 4 years ago