Tools for Accountants, Bookkeepers 
& Small Business Owners
Downloads | Purchase | Support | Links | Main Page | News | Search |  
Products:
Qslip
Prints Deposit Slips
Qxtender
Hosts Plugins
Qxtender Plugins:
Contacts
Exporter
Leads
Exporter
ShipTo Address
Exporter
CA - DE-9/9C
Quarterly Report
CA - DE-542
Contractor Report
IRS - 941 &
Schedule B
NY - NYS-45
Quarterly Report
TX - C-3/C-4
Quarterly Report
 

Qslip - User Guide - Importing from QuickBooks

Prior to exporting from QuickBooks

(optional) When receiving checks, enter the Bank Number from the checks in the memo field in the "Receive Payments" or "Cash Sales" windows.

Qslip will read this from the QB export file.

If you have the customer list feature enabled in Qslip, you can skip entering the bank number here if the customer (and bank number) are in Qslip's customer list.

A stay-on-top customer list viewer (QSviewer) is included with Qslip. It can be handy to keep it open while entering payments received in QBooks -- a quick glance will let you know whether you can skip entering the bank number for a customer.

 

(optional) If you have other info that you wish to place in the memo field, place it after the Bank Number, separated by a comma.

Qslip will read the Bank Number from the QB export file, placing the text after the comma into Qslip's Memo field.

If you are not entering a bank number, place a comma before any memo text you wish to enter.

 

(optional) If you need to assign a single check to more than one payment received transaction, preface the Check Number with a "p" character (eg. p23081) each time it is entered. Qslip will combine the separate transactions into one check item for the deposit.

 

Prepare to Export from QuickBooks

 

To enter and export a new deposit:

Select "Make Deposits" from the Banking menu, or click "Record Deposits" from the main activity center screen.

If you have received payments or entered cash sales, select the items to deposit on "Payments to Deposit" dialog that opens first.

On the "Make Deposit" dialog, set the Deposit To account and Deposit Date.

If you are entering items received for deposit directly in the Make Deposits dialog, follow the optional instructions above to enter bank numbers and other text in the Memo column for each item you enter.

(optional) Set a cash back amount.

To export an existing deposit transaction:

Open a deposit from the deposit account's register, which will display it in the Make Deposits dialog.

 

Export from QuickBooks

1. Click the "Print" button on the Make Deposits dialog.

2. Select "Deposit summary only" when this small dialog appears.

 

3. In the next dialog, select the "File" radio-button.

Ensure "Tab delimited file" or "Comma delimited file" is the selection next to it.

We do not recommend exporting to the "ASCII text file" type, as field information may be truncated.

4. Click "Print" to create the export file.

 

5. Type a name for the file to create, or select one from the list of files. If you always use the same name (eg. deposit.txt), Qslip will load it on startup, saving you the extra step of loading it into Qslip.

6. Click "Save." (if you select a file from the list, you will receive a prompt asking if you want to overwrite the file - choose yes).

note: QuickBooks99 and prior always default to the QuickBooks program folder for this dialog.

 

7. The Export file has now been created, and you can run Qslip immediately (or later).

 

Import to Qslip

 

1. Run Qslip. If this is the first time, you will get an open file dialog. Open the file you exported from QuickBooks.

Subsequently, when you run Qslip, it will open the last file you had open before exiting, skipping this step.

You can also open a file at any time while Qslip is running.

 

2. The selected file (or last viewed file) is loaded into Qslip. If this is not the file you exported from QuickBooks, select "Open" from the "File" menu or click the and use the dialog to open the file you exported.

Any discrepancies in the import file will be displayed in a warning dialog.

The import stage is complete. Now you can get ready to print a deposit slip.

The QuickBooks Bank Account and Deposit Total are shown for reference.

3. (optional) You may change the date.

4. Set the currency and coin amounts. Editing one will change the other, so that currency + coin = cash total.

The current slip format and printer are displayed at the bottom for reference. If not correct, select the proper format.

 

5. (optional) If you haven't entered some or all of the Bank or Check Numbers for the checks in QuickBooks, you can enter them now.

 

6. Print.

Copyright Qtools Software - © all rights reserved

QuickBooks, QuickBooks Pro, QuickBooks Premier & QuickBooks Enterprise are registered trademarks of Intuit, Inc.