Transaction Pro Importer 8 Download The Free

Account Reference Text Reference to the Expense Account Name or Income Account Name associated with the transaction.

SaasAnt Transactions (Desktop) supports QuickBooks Pro, Premier, Enterprise, and Accountant Editions.

Transaction Pro Importer 8 Download The Free

You can download the free trial of the software directly from the SaasAnt Website.

Steps for Importing Bank Transactions to QuickBooks Desktop Importing with SaasAnt Transaction is a breeze with our simplified and powerful Import wizard.

Just follow a simple 3 step process to bulk import your file data to QuickBooks.

You can easily import bank transactions into QuickBooks desktop from excel.

Click the Import button in the Dashboard screen or Import option from the File menu in the menubar to navigate to the File Selection screen of the Import Wizard( Step 1 ).

Step 1 - File Selection: Select QuickBooks Transaction Type as Bank Statement.

Select Your File - You can either click Browse File to browse and select the file from the local computer folder or click Sample Templates to navigate to SaasAnt sample file locally.

Step 2 - Mapping: Set up the mapping of the file columns corresponding to QuickBooks fields.

This step will be automated for you if you use the SaasAnt template file.

Step 3 - Review Import: Review your file data in the Review Grid screen and click Send to QuickBooks to upload your file data to QuickBooks.

How does it work Lets assume that we have a file which contains following bank statement.

Date Description Check No Amount 231218 Subscription payment 12123733 100 231218 Telephone Bill Payment 2121221 1 -900 Bank statement has deposits and Expenses.To import Deposits and Expenses (Checks),we need to mention 1.

Bank Account 2. Income Accounts 3.Expense Accounts 4.Customer or Vendor Names Lets modify the file to add above details.

Date Description Check No Amount Bank Account Account Payee 231218 Subscription payment 12123733 100 HDFC Uncatergorized Income Account John 231218 Telephone Bill Payment 2121221 1 -900 HDFC Telephone Expense Account Telephone Company 1 Now we can import this file using SaasAnt Transactions (Desktop).

If the transaction has POSITIVE Amount, it will be considered as Deposit.

If the transaction has NEGATIVE Amount, it will be considered as Expense Check.

If the file has separate columns for Credit and Debit, It can be be directly mapped too.

Bank Statement Line as Deposit Bank Statement Line as Check Mapping QuickBooks Fields Field Name Format Description Date Date The date when this transaction occurred.

Bank Account Reference Text Name of the Bank Cash Account for this transaction.

Check Number Text (Max Length: 11 Characters) Check Number or Reference number for the transaction.

Description Text (Max Length: 4095 Characters) The Description about the Expense or Deposit Transaction.

Payee Reference Text Reference to Vendor,Employee or Customer.