Enhanced interface

Import bank transactions for reconciliation (Classic)

The classic experience for import transactions is going away in a future release. This change does not impact any custom integrations that use the Intacct API. Try Bank transaction assistant file import for a more robust experience.

Use the classic file import experience to import a CSV or QIF file containing bank transactions into Sage Intacct for reconciliation. Bank transactions automatically match against existing transactions in Sage Intacct using the account's applied rule set. Resolve unmatched transactions by manually matching any transactions that remain or by creating additional transactions.

If the account you're reconciling is connected to a bank feed, importing a CSV or QIF file using the classic file import experience unmatches and removes unreconciled bank feed transactions. Use Bank transaction assistant file import to import transactions without unmatching or removing bank feed transactions during reconciliation.

Before you begin

To match incoming transactions from an import file or bank feed, create rules and add them to a rule set, then assign that rule set to the account.

Reconcile the account within the level or entity in which it was created. For example, if you created the account at the top level, reconcile at the top level. If you created the account in an entity, slide into that entity to reconcile.

Set up entity and user restrictions correctly so that the appropriate user can transact against and reconcile the appropriate accounts.

Upload multiple files for daily or weekly "soft" reconciliations. Avoid duplicate transactions and unexpected results by uploading only the delta (the new transactions) and keeping transactions within the statement ending date.

Step 1. (Skip for QIF files) Download the Bank reconciliation transactions template and input data

Download the template to your computer, enter your information, then upload the file for reconciling. Download the template following the instructions below from the Reconciliation pop-up window.

Make sure that the file is formatted correctly. When you copy and paste bank data into the template, only copy the data portions of the original file, excluding the column heads.

Subscription	Cash Management
User type	Business
Permissions	Reconcile bank: List, View, Add, Edit, Delete

Go to Cash Management > All > Reconciliation > Bank.
Select an Account to reconcile.
Select Import.
Select Bank reconciliation transactions template to download the CSV file.
Enter and format your information in the template and save it to your computer.

Step 2. Import the file

After you enter transaction information in the CSV file, or after you obtain a QIF file from your bank (which you do not need to reformat), you can import the file.

Subscription	Cash Management
User type	Business
Permissions	Reconcile bank: List, View, Add, Edit, Delete

Go to Cash Management > All > Reconciliation > Bank.
Select an Account to reconcile.
Select Import.
Select Choose Files on the Import files pop-up window and select the file.

Remove an import file by selecting the trash can icon.
Select Done.
Select Continue.

Next steps

Intacct matches as many transactions as possible from your imported file to what's entered in your company. Transactions match based on the applied rule set for the account. Imported transactions appear on the Reconcile bank account page on the Bank tab.

Continue to manually match transactions or create additional transactions. When the Amount to reconcile is zero, and with the appropriate permissions, you can finalize the reconciliation.

Field-by-field information: Bank transactions template

The template contains headers and dimensions specific to your company. The headers listed below are for a standard template and might not contain some field definitions specific to your company. Incorrect header titles cause upload errors.

To import dimension values for a transaction, enter information in the appropriate dimension column of the import spreadsheet. Otherwise, no information appears for that dimension for the transaction.

If you relabeled any dimensions (see Terminology for more information), your dimension name doesn’t appear in the CSV template, but the original Intacct dimension name does.

The field definitions below, and in your template, explain what type of information is required for each field and how to enter valid information. For more information, see Prepare your file for CSV import.

Field Name	POSTING_DATE
UI Field Name	Posting Date
Type	Date
Length	10
Default Value	None
Valid Values	MM/DD/YYYY
Dependencies	None
Required	Yes
Editable	No

Field Name	TRANSACTION_TYPE
UI Field Name	N/A
Type	Text
Length	7 or 10
Default Value	None
Valid Values	deposit, withdrawal
Dependencies	None
Required	Yes
Editable	No

Field Name	DOCUMENT_TYPE
UI Field Name	N/A
Type	Text
Length	3, 4, or 5
Default Value	None
Valid Values	ach, card, cheque
Dependencies	None
Required	No
Editable	No

Field Name	DOCUMENT_NUMBER
UI Field Name	Document Number
Type	Alphanumeric
Length	any
Default Value	None
Valid Values	Cheque number, or transaction ID for electronic payments
Dependencies	None
Required	No
Editable	No

Field Name	PAYEE
UI Field Name	Payee
Type	Character
Length	80
Default Value	None
Valid Values
Dependencies	None
Required	No
Editable	No

Field Name	AMOUNT
UI Field Name	Amount
Type	Number
Length	2-38
Default Value	None
Valid Values	Should be non-zero, with negatives designated by a leading dash.
Dependencies	None
Required	Yes
Editable	No

Field Name	DESCRIPTION
UI Field Name	Memo
Type	Character
Length	80
Default Value	None
Valid Values	Any
Dependencies	None
Required	No
Editable	No