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.
- AccountsOnline10 years agoCover User
As a new user of Essentials the functionality to be able to gross up a transactions is also very important for users in New Zealand. We have a number of instances when the functionality to do this at source rather than create a journal would be far more efficient. As a long standing BankLink user this functionality has been available in BankLink for many years. BankLink allows the likes of Amex, Diners, interest less withholding tax and commission payments where deductions have been made to produce a net payment. This is a request for that same functionality so that it can be applied to both manually coded transactions, as well as in memorised/rules processed transactions.
Look forward to this limitation being escalated, as I see the orginal request for this in April 2014.
- 10 years ago
Bump
- Laura-K10 years agoContributing Cover User
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