http://www.baystateconsulting.com

Import Sales Receipts to QuickBooks Online using Transaction Pro Importer on the Intuit App Center

Want a fast and easy way to import your sales receipts transactions into QuickBooks Online?  This application is on Intuit’s newest platform, the Intuit App Center.  There is a free trial available here.

As long as your data is in an Excel or CSV file you can use Transaction Pro Importer for QuickBooks Online to upload these transactions to your QuickBooks Online company file.  Your import file can contain columns in any order, have whatever headers you want and can have extra columns.  We have provide a suggested template for you to review or start with to save you time.  You can download this template here.  If you use the template we provide then you won’t need to map any fields since Transaction Pro Importer automatically maps fields with the same name.

Below is a table showing all the fields supported as well as the data format expected in your import file.  To see the entire table change the number of rows in the show entries box.  We also have this data dictionary available in a Microsoft Excel file here.

QuickBooks FieldQuickBooks Form - Field DescriptionNotesRequired FieldType (D for Date, N for Number and T for Text)
RefNumberSales Receipt - Sale #This field is how TPI knows how to group multiple lines onto the same sales receipt. If you would like to let QuickBooks auto assign the next invoice number select the TPI ipion to Let QuickBooks Auto-Assign Invoice Numbers. TPI still needs a RefNumber for internal grouping even if you enable this option.YT
CustomerSales Receipt - ClientIf using jobs include both the customer and job in the import file separated by a colon (ie. Customer:Job).YT
TxnDateSales Receipt - Sale DateD
ShipDateSales Receipt - Ship DateD
ShipMethodDateSales Receipt - Ship ViaT
ShipMethodIdSales Receipt - Tracking #T
BankAccountSales Receipt - Deposit ToIf using account numbers provide the lowest sub account number and turn on the option to enable account numbers. If using account names include the account and the sub account separated by a colon (eg (Checking:BOA).YT
PaymentMethodSales Receipt - Pmt MethodT
PaymentRefNumber
Sales Receipt - Ref #T
BillAddrLine1
Sales Receipt - Bill ToT
BillAddrLine2
Sales Receipt - Bill ToT
BillAddrLine3
Sales Receipt - Bill ToT
BillAddrLine4

Sales Receipt - Bill ToT
BillAddrLineCity
Sales Receipt - Bill ToT
BillAddrLineStateSales Receipt - Bill ToT
BillAddrLinePostalCodeSales Receipt - Bill ToT
BillAddrLineCountrySales Receipt - Bill ToT
ShipAddrLine1Sales Receipt - Ship To
T
ShipAddrLine2Sales Receipt - Ship ToT
ShipAddrLine3Sales Receipt - Ship ToT
ShipAddrLine4Sales Receipt - Ship ToT
ShipAddrLineCitySales Receipt - Ship ToT
ShipAddrLineStateSales Receipt - Ship ToT
ShipAddrLinePostalCodeSales Receipt - Ship ToT
ShipAddrLineCountrySales Receipt - Ship ToT
NoteSales Recipt - MemoT
MsgSales Receipt - Client MessageT
ToBePrintedSales Receipt - To be printedThe following values can be used. If True: 1,-1,Y,YES, BILLABLE. If not true: 0,FALSE, F,N,NO,NOTBILLABLE.T
ToBeEmailedSales Receipt - To be emailedThe following values can be used. If True: 1,-1,Y,YES, BILLABLE. If not true: 0,FALSE, F,N,NO,NOTBILLABLE.T
ShipAmtSales Receipt - Separate Line item on an invoiceIf your import file contains a separate column that contain shipping charges use these two fields to set up a separate line on the transaction.N
ShipItemSales Receipt - Separate Line item on an invoiceIf your import file contains a separate column that contain shipping charges use these two fields to set up a separate line on the transaction.T
TaxAmtSales Receipt - Tax AmountN
TaxRateSales Receipt - Tax %N
DiscountAmtSales Receipt - Discount AmountN
DiscountRateSales Receipt - Discount %N
DiscountTaxableSales Receipt - Tax
The following values can be used. If True: 1,-1,Y,YES, BILLABLE. If not true: 0,FALSE, F,N,NO,NOTBILLABLE.T
LineItemSales Receipt - Product/ServiceIf using sub items include both the item and sub item in your import file separated by a colon.YT
LineQtySales Receipt - QtyN
LineDescSales Receipt - DescriptionT
LineServiceDateSales Receipt - Service DateD
LineUnitPriceSales Receipt - RateN
LineAmountSales Receipt - AmountN
LineTaxableSales Receipt - TaxThe following values can be used. If True: 1,-1,Y,YES, BILLABLE. If not true: 0,FALSE, F,N,NO,NOTBILLABLE.T
LineClassSales Receipt - ClassT

.

So if your company needs the ability to import sales receipts into QuickBooks Online try the free trial today of Transaction Pro Importer:  The fast and easy way to import your data into QuickBooks Online.

If you have any questions or comments please post them below.
.
.

If you have any questions or comments please post them below.

Comments

  1. Nick Nandwani says:

    I am just trying to do this on QBO, and Im having a problem. When I import the sales receipt excel file, everything imports fine. The only problem is it does not pull the data after it has imported it. This sounds confusing so let me explain further. I have established all the products and the prices in the ITEM list. So I would expect that if I import a list of items and quantities of those items for a sales receipt, the prices would appear on the sales order without me having to import them. I.e. The Value of the order and the value of the items should be pulled from the item list after importing the sales receipt which gives the quantities and the items. These items are the same as those in the product / item list in quickbooks. Right now my sales receipts are all 0 and all the values of all the products are 0. But if I create a new order manually, and type in the item number, the price comes up straight away. If I import a list of item numbers and quantities, the prices don’t come up. This is a problem for me, and its the main reason I need your product.

  2. Nick Nandwani says:

    Dear Karen, thank you for your reply over email. But my problem is still not solved so I am not sure if Transaction Importer can work properly. I emailed you the order sheet and the price list so you can see exactly what I am doing. I hope you received them. I will resend them to you today again. My main issue is that I need to import sales orders from customers. Since you do not provide an import of sales orders, I believe you request to be in the form of Sales Receipts. OK so if I put my sales order in the form of a sales receipt, and provide the LINE ITEM, and LINE QTY. I am not going to provide the LINE ITEM PRICE because I want quickbooks to load up the LINE ITEM price from its PRODUCT/ SERVICES list rather than my list. Why do I prefer that? Because the customer sales order might have the wrong prices because the customer is the one who has created that. The LINE ITEM and LINE QTY are the only things I want to import, and THE LINE ITEM will tally up with the PRODUCT LIST and pull the prices from there. But the problem is that at present everything imports fine using your TRANSACTION IMPORTER except after pulling the LINE ITEM and all the LINE QUANTITIES it does not pull the price from the PRODUCT/SERVICES list in quickbooks (even though the exact LINE ITEM is exactly the same as the product/ services). Instead every LINE ITEM comes up with $0.00 figure. I need it to be able to work together with the product/services list in QBO so prices are correct and I can then send a sales confirmation to the customer to get the order signed off.

Any feedback? Please let us know!

Over nine million transactions have been imported into QuickBooks Online.  Sign up for a free trial here.
Save $50 on a Transaction Pro Importer and Exporter bundle here.
http://www.baystateconsulting.com