Export the paid bills
- Go to Reports and search for Transaction List by Vendor.
- Set the report period to the last two or three years.
- Choose Customize, open Filter, and set Transaction Type to Bill.
- Under Rows/Columns, show Date, Num, Vendor, Amount and Open Balance. Num holds the supplier's invoice number.
- Run the report, choose Export, then Export to Excel.
- Open the file in Excel or Google Sheets, delete the title rows if you like, 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
Amount minus Open Balance is the amount paid. ERPSav reads the bill amount on its own, so the Open Balance column is optional.