Fees · Page guide
Match bank payments
Upload a bank or online payment file and record the matching payments at once.
Open in InsplyInstead of typing each payment, upload the file your bank or payment provider sent. Each row is matched to a bill and you see what will happen before anything is saved. Only people who collect payments can upload. Others can only see past uploads.
Record a bank file
- Under "These payments arrived by", choose Bank transfer, Online payment, Cheque, Cash or Card.
- Under "Payment file (.csv)", choose your file. It must be under 1.5 MB. Split larger files.
- Read the preview. Nothing has been saved yet.
- Select the Record button (it shows how many payments), then confirm.
What the file needs
- An Amount column.
- An Invoice number or Roll number column to find the bill.
- Optional Reference column: it stops the same payment being recorded twice.
- Optional Date column: it sets the payment date.
- Select Download a template for a ready-made example.
What the preview says about each row
- Ready to record, or Part payment: will be recorded.
- Already paid or Duplicate: left out.
- More than owed: left out, because a payment cannot be more than the balance.
- Not found or Several invoices: could not be matched to one bill.
- Can't read: the row is not valid.
- Problem rows are shown first. Fix them in the file and upload again, or collect them by hand.
Recent uploads lists each file with its method, rows, recorded, left out, amount and date.