If payment details are supplied in a file there is the option to import the file into the Sales Ledger.
The format of the file to be imported is as shown below
Column 6 Misc Ref is optional. If there is data in that column and a payment is posted on account that reference will be added. It will not overwrite the Misc Ref if the payment is allocated to an invoice or credit.
In Cash Posting there is an Import Remittances option
If a date or value format is incorrect the import will be halted and the message shown below will be displayed. The file must be corrected before the import is tried again
When the file is able to be imported the payments will displayed
Any lines in red indicate that there is no exact match on the account, you can choose to import them or change the Post column to N to prevent that line from being imported,
Where no invoice is found Not Found - POA will be displayed, if left in the import these lines can be paid on account.
The screen will change depending on if Misc References are used, They will be shown on the Import screen if there are any in the spreadsheet.
When the file and totals have been checked click on accept and you will be taken into the cash allocations screen for the first account. If you check the header you will see the total amount agrees with the Payment amount that is to be posted, If you have payment references to be entered they can be entered here.
On the allocations screen the transactions will have been automatically match off. Any changes can be made in the same was as with standard cash posting
Click on Post and the next account will be loaded.
You will see the total from the first account in the run total, this will accumulate as the postings are done
When all of the imported payments have been allocated the run total will match the spreadsheet total.
Exit and print the daybooks,