File Imports

Because files vary by payroll application and service bureau, during your implementation the files specific to your account will be configured in Finlee. If any of your file formats change, or if you need additional files configured, please contact support@rakedigital.com.

There are four categories of files to import:

Bank files: Bank files contain transactions reported by your bank(s). Once imported, an auto-matching routine will begin and Assure will attempt to match each of the bank transactions to a previously uncleared ledger transaction.
Ledger files: Ledger files are used to build your client ledgers. Examples of ledger files are ACH (payroll) files, tax payment (EFTPS) files, and wire (EDI) files.
Client files: Client files are used to build and update your client list. Available fields in the client list are Id, Name, FEIN, and Status.
Liability files: Liability files are used to store your unpaid tax liability balances. These balances are used to locate Liability Variances in the Subledger Reconciliation.

Under Client Funds Reconciliation on the Navigation Bar, choose Bank Rec. This will bring you to the Import Files page.

You can either click to select the files or drag and drop your files into the window.

The files to be imported will be listed with the file name, date and time, and record count. Note that the record count includes all of the records in the file. Because Assure only reads the records that it needs from the file, this count will change once the file is imported to reflect the number of records actually imported.

You will need to select a file type if it is not automatically detected. For example, a bank file that has an extension of .bai will automatically be identified as a Bank file. If the file is a more generic file type (e.g. csv or txt), you may need to select the appropriate file type.

Here are a list of the File Types and a brief description:

File Type	Common Extensions	Description
Bank	.bai, csv	List of all transactions debited from or credited to your service bureau bank account. Also called a bank statement.
Checks	.csv, .txt	List if checks drawn from your service bureau bank account, often known as Trust, Agency, or Tax checks.
Client List	.csv, .txt	Active client list.
Liability Variance	.csv	Unpaid tax liabilities. When importing a liability variance file type, you will be given the option to Replace or Update Liabilities. If you choose Replace (default), all existing liability balances for every client will be replaced with the liability file(s) in the current import window. Use this option if you are importing a complete list of liability files. If you choose Update, only the liabilities for the companies in the file(s) being imported will be updated. There will be no change to the liability balances of companies not in the files being imported. Use this option if you are uploading a partial list of liabilities.
Payroll	.ach, .txt	All transactions sent to your bank for electronic processing, typically an ACH file.
Returns	.txt, .csv	All ACH returns received by your bank, typically known as an ACH Return file.
Tax Payments	.csv, .tst	List of all tax payment transactions. Only upload this information if it is not already included in your payroll/ACH or Checks file. This is common if you are using a third-party software (not your payroll application) to process tax payments.
Wire	.edi	List of all wires to and from your service bureau bank account initiated by the service bureau.

Once you assign file types to all imported files, the import button appears at the bottom right corner of the screen. Once you click the import button, you will see a status bar next to each file. A green bar indicates that the file import was successful and number of records imported will be displayed.

Note that files always import in the following order:

Client files
Ledger files
Bank file

When importing files that add transactions to the ledger (e.g. payroll or tax payment files), a yellow bar indicates that the file was imported but that the company id could not be found in the client list for one or more records in the file. There are two possible results in this scenario.

Client Added: If the file is configured to look for a company id in a ledger file, the company id will be added to the client list if it is not found in the existing client list. A message will be displayed indicating that the client id was added. From the warning, you can click the Edit icon and update the Client record.
Not Imported: If the ledger file does not contain a company id, Assure can look for a FEIN or company name in a file to cross-reference the client list and identify the company id. If the company id cannot be determined based on the name or FEIN in the file, the record will be skipped and a warning presented. From the warning, you can click the Add icon and manually add the transaction.

Import results can be found in the Activity Log, which can be accessed by clicking See File Import Activity from the Import Files screen, by selecting Activity Log from the Bank Rec Tasks menu, or by clicking More Events in Activity Log from the Notifications.

Generic File Imports

Generic File Imports are available to import bank statement transactions and ledger transactions. File import templates can be found under the help screen. Click Import File Templates to download the available templates.

Bank Statement Transaction Imports

If you need to import additional bank transactions, open the Import_Bank_Template.csv file. Use the file type of Generic Bank. The template fields are as follows:

Statement Date: Date that the transaction cleared the bank REQUIRED FIELD
Bank Account Name: Exact bank account name of the account where the transaction cleared REQUIRED FIELD
Company Id: The Assure company id associated with the bank transaction
Check No: If this is a check that cleared the bank, enter the check number
Details: Transaction description
Amount: Dollar amount of the transaction. Enter the transaction amount as a negative amount if the transaction was a payment and a positive amount if the transaction was a deposit. REQUIRED FIELD

Ledger Transaction Imports

You can import ledger transactions from the .csv file template named Import Ledger Template.csv. Use the file type of Ledger. The template fields are as follows:

Date: Transaction date REQUIRED FIELD
Bank account: Exact bank account name where you expect the transaction to clear REQUIRED FIELD
Company Id: Assure company id associated with the transaction
Check No: Check number, if applicable
Details: Transaction description
Amount: Transaction amount. Enter the transaction amount as a negative amount if the transaction was a payment and a positive amount if the transaction was a deposit REQUIRED FIELD
Tax Code: Tax code associated with the transaction, if applicabe
Trans Type: Transaction type associated with the transaction, if applicable