Dynamics GP Bank Reconciliation Import from PDF Bank Statements

Can Dynamics GP import a PDF bank statement?

No. Electronic Reconcile in Dynamics GP reads text files in a bank format, either BAI or a comma delimited, tab delimited or fixed field layout you define in the Configurator. A PDF is not one of them. The working route is to convert the PDF statement to CSV, shape the rows into the layout your Configurator expects, and bring the file in with Transactions Download. GP then matches checks, deposits and transfers against the checkbook and leaves the rest for you to clear by hand.

The file layout, the menu paths and the matching rules on this page come from Microsoft's own Dynamics GP support articles. The conversion step is where we come in: our converter reads the statement, digital or scanned, and writes the transaction table to CSV so you are not typing a month of activity into a spreadsheet.

Why GP users end up reconciling from PDF statements

BAI2 is a treasury product. Large commercial banks send it every morning, but a community bank loan account, a corporate card, a payroll account at a second bank or an account the company closed last year often has nothing but a monthly PDF. The CSV download most banks do offer tends to stop after a limited window, so a catch-up reconciliation that starts eighteen months back runs out of files quickly.

Timing adds pressure. Microsoft stopped selling new GP subscriptions on April 1, 2026, ends product support on December 31, 2029 and ends security updates on April 30, 2031. Most GP shops are planning a move to Business Central or another system, and auditors and migration partners both want every checkbook reconciled before history is carried over.

How to import a bank statement into Dynamics GP from a PDF

Convert the PDF to CSV, format the rows for your Electronic Reconcile bank format, set up the Configurator and Download Maintenance once, then run Transactions Download and finish in Reconcile Bank Statements. The routine we would follow for one checkbook:

1. Upload the PDF statement with the box at the top of this page and export CSV. Turn on Split Debit/Credit if you want withdrawals and deposits in separate columns.
2. Open the CSV in Excel, keep only the transaction rows, and add a check number column if the statement prints check numbers in the description.
3. Build the detail lines in the layout your Configurator expects (the formula below writes Microsoft's BAI sample layout), paste them into Notepad with the header and trailer lines, and save as a .csv file.
4. In GP, open Cards, Financial, Checkbook and make sure the Bank Account field holds the same account number as the file, on one checkbook only.
5. Set up the layout once in Tools, Routines, Financial, Electronic Reconcile, Configurator, map your codes in Codes Entry, and point a download ID at the file in Download Maintenance.
6. Run Tools, Routines, Financial, Electronic Reconcile, Transactions Download, then finish in Reconcile Bank Statements with the statement ending balance and cutoff date.

The file layout Electronic Reconcile expects

Microsoft publishes a small sample BAI file for GP that you build in Notepad and save as a .csv file. It is the simplest layout to target because the BAI file format in the Configurator fills its fields in by default. Each line starts with a record type: 01 file header, 02 group header with the statement date, 03 account line with the bank account number, 16 one line per transaction, then the 98 and 99 trailers. On a 16 line the second field is the transaction code, the third the amount in cents with no decimal point, the fifth the date as YYMMDD and the eighth the check number.

01,,,,,,,,
02,,,,260831,,,
03,80808080,,,,,,
16,475,125000,,260805,,,1042,
16,475,38619,,260812,,,1043,
16,301,940000,,260815,,,,
98,,,
99,1103619,,2

That file carries two checks (1042 for $1,250.00 and 1043 for $386.19) and one $9,400.00 deposit for account 80808080. Code 475 is the check paid code GP maps by default; 301 is the standard BAI code for a commercial deposit, and it has to appear under Deposits Rec'd in your Codes Entry window. If your converted CSV has the date in column A, the amount in column C (withdrawals negative) and the check number in column D, this Excel formula writes each 16 line:

="16,"&IF(C2<0,475,301)&","&TEXT(ABS(C2)*100,"0")&",,"&TEXT(A2,"yymmdd")&",,,"&D2&","

Fill it down, copy the results into Notepad under the header lines and save. Microsoft warns that Excel strips leading zeros from dates such as 260805, so do not reopen the finished file in Excel. If your statement prints dates without a year, add the year in the CSV before you run the formula.

How Electronic Reconcile matches the imported lines

Microsoft's matching article explains nearly every line that lands on the exception report. The checkbook ID has to match, the transaction cannot already be reconciled or voided, and the transaction code in the file has to be mapped to the right category in Codes Entry.

Two rules catch people on converted files. A check will not clear if the bank date in the file is earlier than the check date in GP, so use the posting date the bank printed, not the date the check was written. And adjustments are never matched, so bank service charges, interest and card fees from the statement still need a Bank Transaction Entry before the checkbook balances.

Common Electronic Reconcile errors on converted files

• Bank Account Number from text file could not be matched to a Checkbook Account Number. Microsoft lists two causes: the account number lost its leading zeros, or the same bank account number sits on more than one checkbook, inactive ones included. Type the 03 line account number exactly as it appears in Checkbook Maintenance.
• Unable to match deposit. The GP deposit date is after the bank date, or two deposits of the same amount fall inside the grace period. Clear those by hand in Reconcile Bank Statements.
• Checks sitting unmatched. The check number column is empty or holds text, so GP falls back to date and amount. Pull the number out of the description into its own column.
• The same file will not download twice. To load a corrected file, clear the earlier download in Electronic Reconcile Summary History first.

What it costs to convert statements for GP

OFXStatement Starter is $49 a month, or $24.50 a month billed yearly, for 2,500 pages from a shared monthly pool, with up to 25 pages per statement. Six checkbooks with 5 page statements for a year is 360 pages, so a full catch-up year usually fits in one month. Plus, at $149 a month, adds bulk upload of 50 files at once and unlimited pages per statement for long commercial statements. You can test 15 pages before paying, no credit card needed.

Scanned and photographed statements go through the same upload, read with OCR. If the statements are for a year-end cleanup rather than a live checkbook, the bookkeeping cleanup converter page walks through batching a year of PDFs.