Perform Your First Sales Receipt Export (How-To)

Article Details

Summary

After you set up Quickbooks Online (QBO) and SaasAnt, you can export Sales Receipts from Gingr and import them into QBO.

Steps

  1. In Gingr, go to Left-hand Navigation: Reports & More » Reports » Sales Receipt.
  2. Select a location and a date or date range.
  3. Select Export (#) for Quickbooks Online.

    Report parameters selection form.

  4. In SaasAnt, select New Import in the left navigation.
  5. On the Import Files instructions page, select the blue Let's Import button.

    Dashboard interface with no data displayed.

  6. On the Import Files page, select Transaction.

    QuickBooks file import options screen.

  7. On the next page, select Sales Receipts.

    QuickBooks import options for transactions.

  8. Upload the Sales Receipt file you exported from Gingr.

    File upload interface with sidebar menu.

  9. Select Start Creating Mapping. SaasAnt saves your mapping, so you do not need to do this again.

    QuickBooks file mapping interface screenshot

  10. Check the field mapping. These fields fill in automatically, but check them for accuracy.

Section 1: Customer, Payments, and Reference Number

  • Sales Receipt No = SalesReceiptNo
  • Customer = Customer
  • Sales Receipt Date = SalesReceiptDate
  • Payment Method = Payment Method
  • Location = Location

Data mapping interface with field selections.

Section 2: Item Details

These fields do not fill in automatically. Select each one from the dropdown in the Uploaded Fields column.

  • Product/Service = Item
  • Product/Service Description = Item Description
  • Product/Service Quantity = Item Quantity
  • Product/Service Rate = Item Rate

Quickbooks item details mapping table.

Sections 3, 4, and 5

You do not need to change any settings in these sections.

Shipping, Billing, and Discounts options

Section 6: Other Fields

Check that Deposit To is set to Gingr A/R. If it is not, select the gear icon to update it.

Quickbooks field mapping interface

  1. Scroll to the bottom and select Preview Mapping. It should look like this:

    QuickBooks sales receipt template preview.

    Left side close-up:

    QuickBooks sales receipt form preview.

    Right side close-up:

    Invoice template with empty fields.

  2. Exit the mapping screen and select Review.
  3. On the Settings screen, turn off Do you want to create Customers, Vendors, Locations, Classes, and Accounts automatically?
  4. Set the date format you prefer.
  5. Optional: Turn off Do you want to use the Transaction Reference Numbers from the uploaded file?
  6. Select Save and Continue.

    Settings page with date format options.

  7. On the Review screen, check for errors, then select Upload at the bottom right. If you see an "Incorrect Date Format" alert, select Upload Anyway.

    Sales receipt data review and upload screen.

  8. Wait for a success message. SaasAnt transactions can take a few minutes to upload.

    Data import success confirmation screen

  9. Go back to Quickbooks Online. You see the Sales Receipts for each day under the Daily Sales customer. They also feed into your Balance Sheet and P&L reports in QBO.

If Something Goes Wrong

If you get an error after you upload, submit a ticket to Gingr Support. Include a screenshot of the error and the date of the report.

Related Articles

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.