PC Financial mastercard statements to Excel and QuickBooks
Drop in PC Financial Mastercard PDFs. Each statement is read by a reader built for this layout and checked against the totals the statement prints.
What this layout is checked against
- Previous balance
- New balance
A statement is labelled Reconciled only when every listed control agrees, and that still doesn't mean every row is right. Where the statement prints a running balance, each row's balance is checked too. The certificate lists each control with the printed figure and the figure read.
What is particular about this layout
Its downloaded PDFs carry a text layer that fails our input check, so they are read by OCR, and every figure used in a check must be read the same by two independent OCR passes.
No purchases or payments total is printed, so the statement is checked on its opening and closing balances and its rows, never on components we add up ourselves.
Dates are printed day first (dd/mm), and the date caption is read before the dates.
Card statements in your books
Card statements are read in the card's own terms: purchases and charges on one side, payments and credits on the other, from the previous balance to the new balance. Export to Excel, CSV, QBO or IIF. A statement that doesn't reconcile exports marked.
Questions
Is this the statement my bank gives me?
It's the PDF statement you download from PC Financial online banking or receive in the mail, for a Mastercard. The bank's own transaction download (CSV or QuickBooks file) is a different thing and usually covers recent months only.
What if my statement looks different?
Banks change their designs. A statement that doesn't match this layout is refused as an unsupported layout, not read with the nearest match, and it isn't counted against your plan.
What about scanned PC Financial statements?
For scanned PDFs this layout is Experimental. They are read and checked, and the certificate labels the result Experimental.
Can I check a whole year at once?
Yes. Put the year's PDFs in one run. Each statement is checked on its own, and consecutive months for the same account are checked for a gap.
See also: every layout · how the checks work · pricing · catch-up and year-end