Export the paid bills
- Go to Reporting, then All reports, and open Payable Invoice Detail.
- Set the date range to the last two or three years and include paid invoices.
- Keep Contact, Invoice Number (or Reference), Invoice Date, Total and Paid columns.
- Choose Export and download the Excel file.
- Open it and save it as CSV.
What the file needs
- One row per bill, with the supplier, the supplier's invoice number and the amount.
- Invoice date, payment date, amount paid and the cheque or payment reference make the matching sharper. Add them if the report offers them.
- Two to three years of history. Split a larger file by year; re-importing an overlapping file never double counts.
Then
Open Supplier payments in ERPSav and drop the file on Import a file. If a column name is not recognised, ERPSav asks which column is which and remembers the answer for next time.
Good to know
In Xero the supplier's invoice number is often in the Reference field. Map that column to Invoice number if ERPSav asks.