Export the paid bills
- Go to Reports, then Saved Searches, then All Saved Searches, and choose New, then Transaction.
- Under Criteria, set Type to Bill, Main Line to true, and Date to the last two or three years.
- Under Results, add Name (the vendor), Reference No., Date, Amount, Amount Paid and Status.
- Save and run the search.
- On the results page, use the CSV export icon to download the file.
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
Reference No. holds the supplier's invoice number. Add Subsidiary to the results if you run several entities; ERPSav reads it as Entity.