How to Match a Credit Card Statement to Bookkeeping
Match statement and bookkeeping rows by event, not by a convenient amount. The account, direction, timing, currency, and supporting record should tell one consistent story.
Credit Card Statement PDF to QIF Converter for Checked Imports
This credit card statement PDF to QIF converter builds a credit-card transaction list from an uploaded PDF. Debits become negative amounts and credits become positive amounts, while descriptions, categories, references, and source-page notes remain available for an import review.
Credit card direction rulePurchases and fees are negative. Payments and merchant credits are positive.
Prepare your QIF import
PDF statement · credit card account file
Preparing your private analysis
Your statement is being secured before analysis begins.
Leave this window open; your private results will load here when ready.
One reviewed statement row becomes one QIF record
Field codes carry a narrow import contract. The PDF remains the statement record.
- D
- Transaction date
- T
- Signed amount
- P
- Payee or source description
- L
- Reviewed category
- M
- Source-page note
Safe import path
- Review the PDF extractionCheck row coverage, dates, signs, and descriptions.
- Use a temporary card accountInspect duplicates, transfers, refunds, and categories.
- Reconcile before live importCompare the test balance and totals with the issued statement.
QIF carries transactions, not the full statement
The export declares a credit card account type and writes one transaction block for each reviewed statement row. It can carry date, signed amount, payee text, reference, category, and memo, but it cannot preserve the PDF layout or every issuer disclosure.
Statement balance, credit limit, payment terms, interest calculations, and dispute notices should still be checked in the original PDF. Keep that file as the cycle record after the transaction import.
Resolve direction and duplicate risk before import
For this export, a purchase or fee is negative and a payment or merchant credit is positive. Confirm that the destination uses the same credit-card convention and that transfers are mapped to the intended counterpart account.
Many finance applications cannot identify a prior import reliably when dates or descriptions changed. Import into a new temporary account first, compare count and totals, then inspect duplicate, refund, reversal, split, and transfer behavior.
Finish the account reconciliation
After the test succeeds, import into the selected credit card account and compare the resulting statement-period balance with the issued document. Investigate any variance rather than adding a balancing transaction with no source evidence.
Preserve the import file only as long as required. QIF is plain text and may expose merchant history even when the account number is masked, so apply controlled storage and deletion.
QIF import gate
- The destination accepts QIF for a credit card account.
- Purchases, fees, payments, credits, refunds, and transfers use the expected direction.
- A temporary-account test produces the expected row count and amount total.
- Existing transactions are checked for duplicates before live import.
- The imported period reconciles to the issued statement without an invented plug.
Example: prevent a second import of the same billing cycle
A user previously imported downloaded transactions, then creates QIF from the issued statement. Similar rows now have slightly different merchant text and the application does not recognize every duplicate.
Test in a separate account, compare dates and amounts with the existing ledger, and import only under a documented duplicate rule. The QIF file should not be treated as proof that a row is new.
When the destination expects columns instead of QIF records, choose the legacy XLS statement converter. For an application data contract, use the credit card statement PDF to JSON tool.
Reconcile the import with the statement
Credit Card Statement Reconciliation From Source to Books
Credit card reconciliation proves that every statement event is represented once in the books and that every book entry assigned to the card has statement support or a named timing reason.
How to Review Credit Card Transfers, Refunds, and Reversals
Rows that fund, move, or undo money need an event identity before they receive a spending category.
Understand the QIF field mapping
The mapping converts reviewed debit and credit evidence into a credit-card amount convention while retaining source context.