Accounting Help

Your Accounting Software questions answered here

Manually Importing Bank Transactions

In this article:
How to Manually Import Bank Transactions
FAQs About the Bank import File Format


Background

You can import your bank or credit card transactions into Patriot as often as needed. Choose between:


How to Manually Import Bank Transactions

Step 1: Download Your Transactions File

  1. Log in to your online bank account.
  2. Download a file containing your bank transactions.
  3. Select CSV or Excel format and save it to your computer.

Step 2: Upload Your File to Patriot

  1. Go to Accounting > Financial Tasks > Manage Imported Transactions.
  2. Click Manually Import Transactions.
  3. Select the bank or credit card account you want to import transactions into.
  4. Upload your file by either:
    • Dragging and dropping it
    • Clicking to browse and select it
  5. If your file does not have a header row, uncheck the box labeled “The first row in my file is a header row.” Otherwise, leave it checked.
  6. Click “Continue.”

Step 3: Match Your Data to Patriot’s Fields

  1. Match the displayed columns on your file to the correct Patriot fields:
    • Post Date
    • Description
    • Amount
    • Amount 2 (if applicable)
  2. Leave any extra columns unselected.
  3. Click “Continue” when finished.

Step 4: Review and Manage Your Imported Transactions

  1. You can accept, dismiss, or categorize transactions.

Here is a sample of downloaded activity from a credit card account. Keep in mind, you can have two amount columns, but any more columns will not be imported into the software.

sample of downloaded activity from a credit card account.

FAQs About the Bank import File Format

.xls, .xlsx, .csv

You can import the Post Date, Description, Amount, and Amount 2 (if your bank exports deposits/withdrawals as two separate columns).  Any other fields in the file will not be imported.

Your import file needs to include all three items:  the Post Date, Description, and up to two Amount columns (if your bank exports deposits/withdrawals as two separate columns.)

Although the file limit is 400 transactions, we recommend you limit your file to 200 entries or less for each upload.

Each bank transaction record should be on a single row in your file, with a column for each field to import. The first row of your file can include a header that labels each column, but it is not required.  You can indicate if your file does not have a header row.  You cannot have any extra lines, borders, or footers in your file.

No, the fields (columns) can be in any order from your bank or former software. You’ll match the fields to our fields after you import the file

Your feedback will not receive a reply. If you have a specific issue, please reach out to our support team here.