Sometimes it is necessary to export a list of your QuickBooks Online transactions to Excel.  These transactions can then be imported into Treasury Software to create your Nacha File.

QuickBooks Online:

Go to:

Reports -- Standard Reports -- From my Accountant -- Select "Transaction List by Date"

Now:

1) Select your Date Range

2) Click on the "Filter" button -- select filter by "Transaction Type" equals -- then select the applicable transaction type

3) Save the Report for future use

Now click on "Export/Print" and choose either Export to Excel or csv

The file will automatically export to your Downloads folder

You can now import this file into Treasury software: 

Importing Transactions

Click on Import Transactions from the icon in the center of the homepage.

Browse to select a file, or 'copy and paste' the fields with data from Excel/csv. 

Important:  If you are selecting an Excel file - please confirm that the file is not open in Excel.

Tip: Browse to select a file is much faster and efficient for large imports.  

Click Next.

First click on the blue lettering "Show all Field Selections"

then, next to "Select" -- click on the down arrow and scroll down

You will need to map the "Name" column as "ACH_Name_Internal (Profile Lookup)"

Map "Amount" -- see below

Amounts
*Negative amounts decrease your balance, and represent payments out to employees or vendors.  Positive amounts increase your balance, and typically represent collections from customers. 

If you are making payments out (e.g., to vendors or employees), and the Amounts on the spreadsheet are positive numbers, you will map the column 'Amount Reverse Sign' to turn them into credits.  Payments out must be credits.

In addition, you may want to add:

•Date   (Mapping a Date will override the default date of 'Next Day'.)

•ID_Number  (Some banks require an ID Number)

•ACH_Email_Address  (The Email feature requires the Corporate or Advanced edition.)

When all the necessary columns are mapped, click Next to continue through the Import Wizard.

Review Records

This screen will display a list of the importable rows and invalid rows.
Please confirm your control totals and counts.

To review the list of Importable or Invalid Rows, click on the “+” sign as shown below.

The Invalid Rows section will list all rows that will not be imported into ACH Universal. The software will automatically mark header rows, footer rows, summation lines, and blank lines as invalid. For each row that is invalid, a check mark will be placed in the appropriate column indicating why the row was invalid.  In the case below, the records were Invalid because the system detected that one was a summary row and the other was a header row.

If a transaction is shown as invalid, you may see that the ABA number is incorrect, for example. 

The grid will display the importable transactions and the basic information.

Once you have verified the importable information is accurate, click Next. If you wish to Cancel the import process and try again, simply hit Cancel.

Click Finish to complete the Import Wizard.

You have finished the first step of bringing in the transaction data for the ACH file.

4. Create an ACH file

You are now ready for the final step: creating the ACH file and transmitting the file to the bank.

Navigate to the 'Create ACH File Page' by either clicking on the icon in the ribbon bar - or the large icon below. 

Below is the Create ACH File page.

You can review the control totals and/or record details on this page - and can review detail records if you choose by running the 'Untransmitted Records' report.

The software will also display the location of where the file will be saved.

When ready, click 'Create ACH File' to create the file.