Use the Banking>Upload E-Statements screen to upload bank or credit card statements, import transaction information from Excel, or capture transaction information from bank feeds to enter or match transactions.
You can use the Bank Feeds feature to download banking and transaction information from registered bank and credit card accounts.
Note: You can import transaction history information from up to 90 days prior to registration. For example, if you register for the Bank Feeds feature on April 1, you can upload transaction history for that account from January of that year onwards.
If you use online banking or credit cards, you can download your statements electronically, and then upload this information to create transactions. This feature can be used for:
Write-up: Saves the effort of entering transactions manually.
Client Accounting Services: Matches transactions already entered into the system to determine which have cleared the bank.
You can import bank and credit card statements in the following formats:
Microsoft Excel (files with the extensions XLS, XLSX, and CSV)
Microsoft Money (files with the extension OFX)
Quicken 2003 or later (files with the extension QBX)
QuickBooks Web Connect (files with the extension QBO)
For bank and credit card statements in Excel format, ensure that files are formatted according to the sample template available from the Template option in the Related Actions panel of the Upload E-Statements screen. The headings in your statement must match the headings in the template, and red column headings in the template indicate required entries. The Entry Types tab lists the valid entries for the Type column.
To upload transaction information:
From the Import field of the Upload E-Statements screen, click:
E-Bank to upload bank statements
Credit Card to upload credit card statements
Form the Format field select:
OFX - to upload a Microsoft Money, Quicken, or QuickBooks Web Connect file
Excel - to upload transactions from an Excel file based on the supplied template
Bank Feeds - to import information from an established Bank Feed
Select the account from which to import or upload transactions from the drop-down list in the Account field.
Specify the date range of the data
to import using the From and
To fields.
These fields default to the current month, but you can change this
range to a different month, a range of more than a month, or a range
of only a few days at a time.
Note: You can only import data
once for each bank for a selected date range.
Click Choose File in the Select File field to navigate to and select the file you downloaded from your bank.
Click Import to upload the information in the file or spreadsheet, or click Bank Feeds to sync bank feed information.
Use the options in the Exceptions
panel to indicate how to resolve each exception, and click Save.
By default, the Clear Transaction
checkbox is selected. To add a transaction, deselect the Clear
Transaction checkbox, click the Add
Transaction checkbox, and click Save.
Click View Transactions to move to the Write Up>Transaction Entry screen to edit and post items identified as New Transactions using the Cash Disbursements and Cash Journals.
Edit the transaction as necessary
and click Post to post the
transaction for the active journal.
After transactions are posted, they clear the Bank
Reconciliation.
Note: You can import the identical
data again, but you must clear all unposted new transactions before importing
again to prevent duplicate entries. Matched transactions are not affected.
For more information about editing and posting transactions, see Enter or Post Transactions.