Home | About Us | Back

How to Generate the Proper Report Format Using QUICKBOOKS Software

Create a Generic / Text Only printer driver that prints to a FILE:
(use the Printer Wizard and follow directions)

Create a report and print it using the new printer driver.  Your report should 
look something like this:

------------------------------------------------------------------------------------------
06/28/10                                Your Mall Name

4:35 PM                                Item Summary


                  Date: 6/26/2010 12:00:00 AM  to 06/26/2010 11:59:59 PM


DeptName              Qty SoldVendor  Item Name               Size    ExtPrice  ExtCost

Jewelry Junkies          1        BraceletJJ142A                      10.00     0.00

                         1        BraceletJJ142A                      10.00     0.00

Jewelry Junkies          1        BraceletSilverCharmJJ219            14.00     0.00

                         1        BraceletSilverCharmJJ219            14.00     0.00
------------------------------------------------------------------------------------------

Where Jewelry Junkies should be your dealer numbers instead.  This report used the dealer name.  
Also note that stock numbers were included in the description.  You should be able to 
configure your report similar to this.  If not we will have to do some tweaking.

Also, the report is only for one day and the date info is extracted after the word "Date:"
shown on the 5th line above.

Name it qb.txt.  Replace existing file as necessary.

Run the shortcut for SALES_UPLOAD.BAT on your desktop.

Because the upload method used for QuickBooks is for selected days (ie 1one day) out of the month, 
be sure to check your sales between uploads.  Checking your sales after uploading finalizes the 
upload process and makes it possible to upload again without losing data.

Back to Store Page instructions