To import allocations for multiple accounts at a time the Remittance import can be used. With this you import all the transactions that are being paid for each account and the payment value. The system will create the receipt transactions for each account and match them to the invoices.
If you do not have the Remittance import, please request this from support will be able to assist.
The setup for this is as follows:
Company Details Setup
Go to System Admin from the Toolbar.
From Company Details.
Click the Sales tab followed by the Other sub tab.
Set the Imported Receipts field to the sales receipt of your choice.
If you do not have a batched receipt transaction type you will need to create one.
Import Process
Go to Sales Ledger from the Toolbar.
Click Postings.
Click on the RMB in top table.
Select CSV Remittance Import.
Select a file to import and run it.
The Account is the account that the allocation will be done on. If you are doing group allocations this should be the head office.
The Reference is the remittance reference. Think of this an allocation reference so would have one reference per account which will equate to one allocation session per account.
When the import has run it will create a new batch for you. In the Details tab click Add Items To Batch to view the batch details.
In the top half of the screen will be a remittance for each reference (column 2) in the import file. In the bottom half of the screen is each invoice to be paid on that remittance.
If you need to make any changes, make them and then verify the remittances by right clicking in the top table and selecting Verify.
Once there are no verification error RMB in the top table and select Create Transactions and Allocations.
This converts the remittance batch to a standard batch of cash receipts (1 receipt per remittance header) and will automatically match the receipts and invoices on an open allocation session.
The batch is now a normal batch of receipts. You can go into the Details and view/edit the receipts as normal and the same with the allocation sessions it has generated.
You then just Post the batch of receipts as you normally would. The allocation sessions will be automatically committed and the invoices/receipts go to history (if fully paid).