Qslip - User Guide -
Importing from QuickBooks
Prior to exporting from
QuickBooks
|
1.
(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.
|
|
2.
(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.
|
3. 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.
Export from QuickBooks
|
1.
At the "Make Deposit" window, after selecting
items for deposit, click the "Print" button.
|
|
2.
In QB99 and above, select "Deposit summary only"
when this dialog appears.
|
|
3. In the next window, select the "File" radio-button, and ensure "Tab delimited file" or "Comma delimited file" is the selection next to it. You can use the "ASCII text file"
type, but field information may be truncated.
4. Click "Print."
|
|
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 slip format is
displayed at the bottom for reference. If this is 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.
(optional) Click "Preview" to verify the
deposit information as it will be printed.
7. (first time only) Setup your deposit slip layout and adjust it for printing.
8. Place a blank pre-printed
deposit slip in your printer. (details).
9. Click "Print."
|
|
