wefinly Vendor statement reconciliation Beta Files never leave your browser
Accounts payable

Vendor statement reconciliation

Compare a vendor's statement with your books, line by line. It matches what agrees, explains every difference down to the cent, and gives you an Excel workpaper to file or send to the vendor.

Starting the reconciliation engine...

1

Vendor statement

The statement your vendor sent you, as Excel (.xlsx, .xls) or CSV.

Waiting for file
or drop it here

Not sure what the file should look like?

2

Your books: open bills

Open items for this vendor from your accounting system, for example QuickBooks "A/P Aging Detail". Add several reports if your vendor deals with more than one of your companies; reports covering several vendors are fine too.

Waiting for file
or drop them here. You can add several, for example one per company.

Not sure what the file should look like?

3

Full history (optional)

Every transaction with the vendor, paid or not, for example QuickBooks "Transaction List by Vendor" for all dates. It tells apart invoices you already paid from ones you never entered.

Optional
or drop them here. You can add several, for example one per company.

Not sure what the file should look like?

4

Reconciliation

Review the matches, then download the workpaper.

Needs steps 1 and 2

Saved column templates

Saved in this browser only. A file with the same columns is mapped automatically next time.