Invoice payment work stacks let you export invoice payment details to a spreadsheet. In addition to the standard export, you also have the option to export in a format that is suitable for uploading to Sage 50.
Invoice or payment-level exports
By default, Sage 50 exports will be created at invoice-level, with a nominal code assigned per-invoice.
Administrators can enable invoice line-level exports in Settings - Company Setup - Customisations:
This will also mean that your invoice records will show nominal codes per line instead of at invoice level.
Creating the file for upload
1. Open your invoice payments stack
This will be named based on your business' preferences and is typically accessible from the Stock or Finance tabs.
2. Click "Sage 50" button
Example output (with line-level setting enabled):
3. Review file
Check your export to ensure that your date range for import is filtered correctly. To do this, select the filter icon in the Date column), select Date Filters and after. Enter the day after the date of the last payment import.
Invoice-level export users onlyAdd a column named 'Nominal’ and add the relevant bank account that the transactions should be imported to. If you have multiple accounts, use the ‘details’ tab to confirm the customer method of payment. |
4. Save your file
Save a copy of your file to your chosen location, and give it an easy-to-identify name such as 011221_071221_SalesPayments_Sage_ML. We’ve used this naming convention to identify the date range applied (1st December 2021 – 7th December 2021) and also the transaction type (SA – Sales Payment on Account).
5. Open Sage 50, and from the File menu, select Import.
6. Select Audit Trail transactions.
7. Select the data source
Select the file you saved before, then click Next.
8. Map the fields
In The Field Mappings screen, map up the fields from your import file to the available Sage Fields.
The fields show in this example may differ:
*Please note that if you change the name of the column header in your spreadsheet you will need to map this to the correct Sage Field name.
9. Save the mapping file
The first time you import your file, it is important to save the mappings. Click ‘Save Map’ and name the mapping file as Sales Payments - The Layer.
10. Finalise the import
Click on Import.
11. Check results
If there are any issues with your data, you’ll see an error prompt which highlights the cell that has the issue (don’t forget to exclude the header column in the count). You can then edit the changes and save the file before trying again.
If all has gone well, you’ll see an import results file, which can be printed if required.
Please be vigilant when importing data, as Sage will allow you to duplicate import data. As such, it is key that strict date ranges are referenced during the import stage. If you have any issues with duplication of import, please contact Sage support for assistance.
Customer record view
In a customer record, you can now filter by transaction number or type to view all sales payments on account (SA). By importing the invoice reference linked to the payment, you are able to match up sales payments to sales invoice (SI).
Bank Accounts View
You will see all imported transactions in the bank account view.
