Deltek Vantagepoint Bank Reconciliation Import from PDF Statements
Oct 8, 2026
Convert your bank statement to OFX now
PDF, JPG, PNG, BMP, HEIC, TIFF
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF
Uploading...
All data: Extracts every table and text field from each page.
Deltek Vantagepoint does not read a PDF bank statement. Its bank reconciliation imports a delimited .txt or .csv file whose layout you define once on the Import tab of Banks settings, then matches each line to posted checks and receipts by amount and reference number or by amount and date. Convert the PDF statement to CSV, map its columns to that layout, and import it with Import Transactions.
That is the whole route in one paragraph. The rest of this article covers the Import tab settings that decide whether the file loads, how the matching rules treat checks and deposits, and what a converted statement looks like when it lands. The form names and options come from Deltek's Vantagepoint help on help.deltek.com.
Why architecture and engineering firms end up with PDF statements
Vantagepoint is the project accounting system of a large share of US architecture, engineering and consulting firms. The bank side of those firms is rarely tidy. The operating account at the main bank may offer a CSV download for the last few months, but the payroll account, the money market sweep, the account opened for a single government contract and the account at the bank a partner brought in when the firm merged usually do not. When the audit or the year end close comes around, the history for those accounts is a folder of monthly PDF statements.
Deltek's own procedure says it plainly: get the file from your bank and convert it to a format that matches the import configuration you set up. A PDF is not a file you can convert by renaming it. Somebody either retypes the lines or a converter reads them.
What the Vantagepoint import file needs
You set the layout under Settings, Cash Management, Banks, on the Import tab. The tab only appears after you select Import Enabled on the Options tab of the same bank. These are the settings that matter for a CSV made from a PDF statement.
| Import tab setting | What it controls | Value for a converted CSV |
|---|---|---|
| Field Delimiter | The character between fields | Comma |
| Text Qualifier | The quote around text fields | Double quotation mark, because descriptions often contain commas |
| Date Order, Date Delimiter, Leading Zeros, Four Digit Years | How dates are parsed | Match the dates in the file, for example MDY with a slash and four digit years |
| Define Receipt/Payment | How Vantagepoint tells deposits from payments | Separate Columns when the statement has deposit and withdrawal columns, or Receipts greater than zero for a single signed amount |
| Import Details grid | Which predefined fields the file carries | Date, Reference Number, Payee/Description and Amount, or Receipt Amount and Payment Amount |
| User defined fields 1 to 5 | Extra columns you want to keep | Optional, for example the full statement description |
The predefined fields are Date, Reference Number, Payee/Description, Type, Amount, Receipt Amount and Payment Amount. Type is only used with the Type Mapping option, and Receipt Amount and Payment Amount only with Separate Columns. Deltek also says to remove any data you do not want to import, so delete the running balance column in Excel before you save the file.
How Vantagepoint matches imported lines
Matching is where a good file saves the most time. Each bank has a payment matching grid and a receipt matching grid, and each transaction type gets one of two rules.
| Matching rule | Default for | What it needs from the file |
|---|---|---|
| Amount and Refno | Check related transactions | The check number in the Reference Number field, and the exact amount |
| Amount and Date | Non check transactions such as deposits and transfers | The amount and a date within your Days +/- tolerance |
Payment Days +/-, Payment Amount +/-, Receipt Days +/- and Receipt Amount +/- set how far a suggestion can drift from the posted record. Automatically Clear Matched Transactions decides whether matches clear on their own or wait for review. Anything left unmatched after import is matched by hand.
The practical consequence: checks match on number, so the Reference Number column has to carry the check number. Our converter keeps the check number from the statement, either from the check number column or from a line like CHECK 1045, and writes it in a Check Number column at the end of the CSV. Map that column to Reference Number and checks match on the first pass.
How to import a PDF bank statement into Vantagepoint
- Upload the PDF with the converter at the top of this page and check the rows against the beginning and ending balances printed on the statement. Scanned statements go through OCR the same way.
- Export CSV. Open it in Excel, delete the running balance column and anything else you do not import, put the columns in the order your Import tab expects, and save as CSV.
- Once per bank, in Settings, Cash Management, Banks, select Import Enabled on the Options tab, then fill in the Import tab: comma delimiter, double quote qualifier, date settings, the Define Receipt/Payment option and the fields in the Import Details grid.
- In Cash Management, Bank Reconciliation, create the bank statement for the period, or open an existing one.
- Click Import Transactions, then Browse, pick the CSV and click Open. Click Save, check the number of valid records the dialog reports, and click Import.
- Review the suggested matches on the Import tab of the Bank Reconciliation form, match what is left by hand, add entries for bank interest and fees, and reconcile the statement.
Importing again into the same statement overwrites the earlier import after you confirm, so a corrected file simply replaces the first one. If you need to back out completely, Vantagepoint has an undo for imported bank transactions.
Three problems that come up on the first import
- Zero valid records. Usually the delimiter, the text qualifier or the date settings do not match the file. A description with a comma and no qualifier shifts every column after it.
- Deposits imported as payments. The Define Receipt/Payment option does not fit the file. A single Amount column with negative withdrawals needs Receipts greater than zero; separate deposit and withdrawal columns need Separate Columns.
- Checks not matching. The check number is not in Reference Number, or the check was posted under a different number. Fix the mapping, or correct the posted record, and import again.
Is it worth paying for a converter for this?
It depends on the volume. A firm that reconciles one account with 40 lines a month can retype them. A firm with six accounts, a year of unreconciled history before an audit, or an outsourced accountant serving several Vantagepoint clients is looking at thousands of lines, and every typing mistake turns into a difference somebody has to find later.
| Option | Cost | Fits |
|---|---|---|
| Retype the lines into Excel | Staff time, roughly an hour per 100 lines with checking | A single small account |
| Ask the bank for a CSV or BAI file | Free where offered, often limited to recent months or a treasury package | Current months on the main account |
| OFXStatement Starter | $49 a month, or $24.50 a month billed yearly, for 2,500 pages | A catch-up year across several accounts |
| OFXStatement Plus | $149 a month for 10,000 pages, bulk upload of up to 50 statements | Firms and outside accountants with several clients or entities |
You can test 15 pages with no credit card before you pay, which is enough to run one statement through the whole route above and see the match rate in your own Vantagepoint.
Other systems, same job
If part of the firm runs on another system, the same converted statement works there too. Acumatica reads it as OFX, see Acumatica bank reconciliation import from PDF statements, and Dynamics GP reads a delimited file through Electronic Reconcile, covered on our Dynamics GP bank statement import page. For a plain spreadsheet of any statement, use the PDF bank statement to CSV converter.
Deposits are the other half of the reconciliation. For a project firm most of them are client payments, and when the deposit you are waiting for never shows up on the statement, chasing overdue client invoices is the next job on the list.
Who this is for
This route is for the controller or accounting manager at an architecture, engineering or consulting firm on Vantagepoint who has accounts with no usable bank download, for the accountant catching up months that were never reconciled before an audit, and for the outsourced accounting firm that runs Vantagepoint for several clients. If your bank already gives you a clean CSV for every account and every month, you do not need a converter. If even one account exists only as PDF statements, converting it is the fastest way to get it reconciled.