Manually Importing Your Bank Transactions
You can manually import your bank or credit card transactions into Patriot as often as needed. You can also connect your bank account for automatic imports. For more details, see Connecting Your Bank Accounts for Accounting Journal Entries.
How to manually import a bank transaction
Here are some FAQs about the file format:
Which transaction fields can I import?
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.
What are the fields required in order to import transactions?
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).
What file types can I use?
.xls, .xlsx, .csv
How should the file be formatted?
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.
Do the order of the fields matter?
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.
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.
When you are ready to import your file
- First, you will need to log in to your online bank account software and download a file containing your bank transaction activity. Choose the .csv or Excel format option. Save this file to your computer.
- Go to Accounting > Financial Tasks > Manage Imported Transactions
- Click “Manually Import Transactions.”
- Select the bank or credit card account you want to import, and drag and drop or choose the downloaded file from your computer.
- If your file does not contain a header row, and your data to be imported begins on row 1, uncheck the box “The first row in my file is a header row. Otherwise, leave the box checked if you have a header row, like the example pictured above.
- Click Continue.
Match your data to Patriot fields
Next, your column headers from your file will appear. Choose the matching Patriot data field for the Post Date, Description, Amount, and Amount 2 (only if your file has two amount columns). If your file contains extra columns that won’t be used, just leave those unselected. Click Continue when you are finished.
Review Your Imported Transactions
You will see a list of your imported transactions from your file. Select the account to charge each transaction, and select a department, if needed.
For each bank transaction, click the green checkmark to record it as a journal entry. Click the trashcan to dismiss the transaction.
If you have Accounting Premium, you can attach electronic files and receipts to this transaction by clicking the gear at the end of the row. See Managing Your Receipts and Documents for details.
If you neither record or dismiss a transaction, and click “Post Transactions,” you will see a warning that these transactions will be automatically dismissed. If you realize you do need these transactions recorded, click “Return to Import” to go back to the previous page to accept or dismiss. Keep in mind, you can import your bank file again to record any transactions you may have accidentally dismissed.
You can also save your progress by clicking the button in the top left. You can come back to this page later to finish by going to Accounting > Financial Tasks > Manage Imported Transactions > Manually Import Transactions.
After you have accepted or dismissed your transactions, you will see a Transactions Summary. You will also see these transactions in your Activity by Account Report.
Voiding Imported Transactions
If needed, you can void each transaction even after you have recorded it. While on the Transactions Summary page, click “Void” at the end of the row and confirm the void.
You can also edit, void, or delete this transaction from the Activity by Account report. Click the three lined icon under the Details column, and choose your action.