Acumatica reconciles from a bank file, your bank sent a PDF. Upload a bank statement, digital or scanned, and get an OFX file Acumatica imports in a few minutes.
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF
Uploading...
No. Acumatica imports OFX, QFX, QuickBooks Web Connect (.qbo) and Excel bank statements on the Import Bank Transactions (CA306500) form. Convert the PDF statement to OFX with the tool above, upload it to the cash account, then run Auto-Match on Process Bank Transactions. The check number and ending balance come across with the file.
Acumatica reconciles quickly once the bank activity is in. Second banks, card programs, closed accounts and pre go live months only exist as PDF statements.
Import Bank Transactions reads OFX, QFX, QuickBooks Web Connect (.qbo) and Excel.
Feeds start at the connection date and skip some banks.
Hours per account, and every typo becomes a difference.
Upload the statement, export OFX, upload it to the cash account, auto match.
OFX 1.02 with dates, ending balance and a stable ID per line.
The tag Acumatica reads first when it matches references.
Paper and photographed statements convert like digital PDFs.
The same statement converts to the same IDs, so a re-upload is refused.
Up to 50 statements at once for implementation history loads.
Statements are encrypted in transit and at rest.
One month, or a full catch-up year.
Drop the statement in the converter above.
Check the totals against the printed balances.
Pick the cash account, Acumatica builds the statement.
Match on Process Bank Transactions, then reconcile.
Finance teams on Acumatica and the partners who implement it.
Every cash account closed on time, including the ones with no feed.
Opening history loaded during an implementation or migration.
Subcontractor and supplier checks matched by check number.
No. Acumatica imports bank statements from OFX, QFX, QuickBooks Web Connect (.qbo) and Excel files on the Import Bank Transactions (CA306500) form, and a PDF is not on that list. To reconcile a month that only exists as a PDF statement, convert it to OFX with the tool above and upload the file to the cash account. Acumatica then creates the bank statement, reads the ending balance and lets you auto match the lines on Process Bank Transactions.
The form names, file rules and matching order on this page come from the Acumatica Cash Management documentation (published in the same wording under the MYOB Acumatica and Visma brands). Our part is the file. The converter reads the statement, digital or scanned, and writes an OFX 1.02 file with a stable transaction ID on every line, the payee in the name field and the check number in its own tag when the statement prints one.
Most Acumatica customers connect their main operating account to a bank feed and never think about statement files. The gaps show up on the edges. A second bank holds the payroll or the loan account and has no feed connection. A corporate card program only offers statements. An account was closed before go live and the auditor still wants its last six months reconciled. A company moving to Acumatica from QuickBooks, Sage or Dynamics GP needs opening history that no feed will ever reach back to. And a construction company on Acumatica Construction Edition clearing hundreds of subcontractor checks a month needs every check matched by number, not eyeballed.
| Way to bring bank activity into Acumatica | Form | Good for |
|---|---|---|
| Bank feed | Cash Accounts and the bank feed setup | Primary accounts at banks the feed provider supports, from the connection date forward |
| Bank file from online banking | Import Bank Transactions (CA306500) | Accounts where the bank still offers an OFX or QFX download for the period |
| Excel upload | Process Bank Transactions (CA306000) or an import scenario | Teams willing to retype or reshape lines into a spreadsheet |
| PDF statement converted to OFX | The same Import Bank Transactions form | Second banks, card programs, closed accounts and catch-up months, from $49 a month for 2,500 pages |
Acumatica is specific about which tags it uses, and that is what decides whether a converted statement imports cleanly. The table lists each value Acumatica takes from the file and what our converter writes there.
| What Acumatica reads | OFX tag | What the converted file carries |
|---|---|---|
| Bank account identifier, matched to External Ref. Number on the cash account | ACCTID | The account number printed on the statement, or ACCT001 when the statement does not print one |
| Currency, which must match the cash account | CURDEF | USD by default |
| Statement start and end dates | DTSTART and DTEND | The first and last transaction dates on the statement |
| Ending balance and statement date | LEDGERBAL (BALAMT and DTASOF) | The closing balance, written only when the statement prints one |
| Reference number used for matching | CHECKNUM, then REFNUM, then FITID | The check number when the statement prints it, otherwise the stable transaction ID |
| Payee | PAYEE NAME or NAME | The statement description, cut to the 32 characters OFX allows, with the full text in MEMO |
| Receipt or disbursement | The sign of TRNAMT | Positive for deposits, negative for payments, so the type follows the sign as Acumatica expects |
Two details matter more than the rest. First, Acumatica uses CHECKNUM ahead of any other reference when it matches lines to payments, so check payments recorded with the check number as the reference match on the first pass. Second, OFX carries no beginning balance. Acumatica takes it from the ending balance of the previous imported statement, and you type the beginning balance by hand only for the first statement on a cash account.
Setup is a one time job of a few minutes. After that each statement is upload, convert, upload again.
A thread on the Acumatica community forum reports that .qbo and QFX files failed on the standard import service while OFX works. Our converter writes OFX, which is the format the service was built around.
Acumatica runs accounting at US distributors, manufacturers, service firms and, through Construction Edition, general contractors and subcontractors. The people converting statements for it are controllers who need every cash account reconciled at month end, including the ones without a feed; Acumatica partners and consultants loading history during an implementation; and outsourced accounting firms finishing a backlog of reconciliations before an audit or a lender review. They want the same result: the bank statement in Acumatica, the lines matched, and a difference of zero.
OFXStatement Starter is $49 a month, or $24.50 a month on the annual plan, for 2,500 pages from one shared pool, with statements up to 25 pages each. A busy operating account prints 10 to 40 pages a month, so a catch-up year on one account is roughly 120 to 480 pages, and several accounts fit in one Starter month. Plus is $149 a month for 10,000 pages, removes the per statement page cap and adds bulk upload of up to 50 files at once, which suits a partner loading history for several clients. You can test 15 pages without a credit card before you pay.
Compare that with keying a 300 line statement into Excel to use the spreadsheet import. That is half a day per account per month, and a typing error there turns into a reconciling difference you then have to hunt down.
No. Acumatica imports OFX, QFX, QuickBooks Web Connect (.qbo) and Excel files on the Import Bank Transactions (CA306500) form, not PDFs. Convert the PDF statement to OFX first, then upload it to the cash account and match the lines on Process Bank Transactions.
OFX, QFX and QuickBooks Web Connect (.qbo) through the PX.Objects.CA.OFXStatementReader import service, with OFX versions 1.x and 2.x supported, plus Excel. A single Excel statement can be uploaded on Process Bank Transactions; several statements in one workbook need an import scenario.
Set the OFX import service on the cash account or in Cash Management Preferences, enter the bank account identifier in External Ref. Number, then open Import Bank Transactions (CA306500), select the cash account and click Upload File. Match and process the lines on Process Bank Transactions (CA306000).
Acumatica matches imported lines to documents by reference number, date and payee. For the reference it reads CHECKNUM first, then REFNUM, then FITID. Click Auto-Match on Process Bank Transactions, review the result, create payments for unmatched lines and click Process.
OFX files carry an ending balance but no beginning balance. Acumatica uses the ending balance of the previous imported statement as the next beginning balance, so you only type it for the first statement on each cash account.
Yes, one statement per file, in date order. Acumatica requires statement periods that do not intersect and rejects transactions it has already imported, so convert each month separately and upload the oldest first.
OFXStatement Starter is $49 a month, or $24.50 a month billed yearly, for 2,500 pages, enough for a catch-up year on several accounts. Plus is $149 a month for 10,000 pages with bulk upload. You can test 15 pages with no credit card.
The same job in Vantagepoint, with a CSV import layout.
PDF statements into Sage Intacct bank reconciliation.
PDF statements to the file Dynamics GP Electronic Reconcile reads.
Clear Viewpoint Vista checks from PDF bank statements.
Convert a PDF or scanned statement into an OFX file.
Catch-up and cleanup work from PDF statements.
Get started converting bank statements to OFX.
USD
per month
per month
$294 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion with bulk upload, custom templates and reports.
USD
per month
per month
$894 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
