Month-end tool
Ledger Routine. Matches a client's bank and card lines to their receipts, bills and invoices, and lists the few it can't settle.
Your files stay on this computer. Everything runs inside this page. Nothing is uploaded or sent anywhere, and nothing is posted to QuickBooks or Xero until you import the files yourself.
A made-up contractor's October: checking, an Amex card, savings, receipts, bills and invoices.
1. Client
2. Bank and card exports
CSV exports from the bank or card website. Several accounts at once is fine: transfers and card payments between them are paired automatically.
3. Receipts, bills and invoices
CSV exports from Dext, Hubdoc, QuickBooks, Xero or a spreadsheet, with at least a date, a vendor or customer, and an amount.
Add at least one bank or card export.
4. Results
Questions for the client
Answer what you can, or copy the questions into an email to the client. Answered lines are settled and remembered for next month.
Files
Only settled lines go into the journal files. Before the first import, compare the column headers with the example file on the import screen in QuickBooks or Xero; they vary by region.