We are going to import payments soon so here my solution to the problem of single payments for muliple invoices is as follows:
1. apply each payment in turn to the invoice but make the payment receipted to the "1-1140 Undeposited Funds" account (or equivalent)
2. import a GJ for each batch of payments with the total payment amount and the following account allocation:
CR 1-1140 Undeposit Funds xxx.xx
DR 1-1105 Cheque Account xxx.xx
3. Go into "Prepare Bank Deposit" on the "Banking" command centre. Since the GJ must exactly match the payments applied you can just tick all and they will net to $0.00 then write in the memo: "Debtor payments batching" or something else to your preference and record the transaction.
I will set up Excel spreadsheets to work out the fields and the accounts then a macro to auto save the .csv files so they are ready for import.
I can't see why this wouldn't work but please let me know if there is any flaw.
Regards,
Tim
Related Content
- 2 years ago
- 2 years ago