How to mass import sales receipts

orlando-perryjm- · ‎March 17, 2023

I see options to import Invoices and Sale journals but nothing for sales receipts.

Trish_T · ‎March 17, 2023

Hi orlando-perryjm,

Thanks for reaching out here. Welcome! QuickBooks Online currently doesn't have the option to import sales receipts. I can see how beneficial this would be, and I suggest providing a suggestion to our Development Team for product updates and feature enhancements. In the interim, I recommend reviewing third party apps for the best fit for your business needs.

If you have any other questions, feel free to reach back out. We'd be happy to help!

View solution in original post

Trish_T · ‎March 17, 2023

Hi orlando-perryjm,

Thanks for reaching out here. Welcome! QuickBooks Online currently doesn't have the option to import sales receipts. I can see how beneficial this would be, and I suggest providing a suggestion to our Development Team for product updates and feature enhancements. In the interim, I recommend reviewing third party apps for the best fit for your business needs.

If you have any other questions, feel free to reach back out. We'd be happy to help!

orlando-perryjm- · ‎March 17, 2023

Thank you.

Trish_T · ‎March 17, 2023

Hi orlando-perryjm-,

You're very welcome. All the best!

Fiat Lux - ASIA · ‎March 18, 2023

@orlando-perryjm-

Prepare your Sales Receipt data with the following template

RefNumber

Customer

TxnDate

ShipDate

ShipMethodName

TrackingNum

Location

Class

BankAccount

PaymentMethod

PaymentRefNumber

BillAddrLine1

BillAddrLine2

BillAddrLine3

BillAddrLine4

BillAddrCity

BillAddrState

BillAddrPostalCode

BillAddrCountry

ShipAddrLine1

ShipAddrLine2

ShipAddrLine3

ShipAddrLine4

ShipAddrCity

ShipAddrState

ShipAddrPostalCode

ShipAddrCountry

PrivateNote

Msg

Currency

ExchangeRate

BillEmail

ToBePrinted

ToBeEmailed

ShipAmt

ShipItem

TipAmt

DiscountAmt

DiscountRate

TaxRate

TaxAmt

DiscountTaxable

LineServiceDate

LineItem

LineDesc

LineQty

LineUnitPrice

LineAmount

LineClass

LineTaxable

101

Janice Johnson

01/10/2020

Checking

Check

20013

110 Main Street

Suite 2000

Dallas

TX

99875

110 Main Street

Suite 2000

Dallas

TX

99875

Special Handling

Thank you for your order!

[email address removed]

N

Y

0.02

Y

Leather Case

2

10

TAX

101

Janice Johnson

01/10/2020

Checking

Check

20013

110 Main Street

Suite 2000

Dallas

TX

99875

110 Main Street

Suite 2000

Dallas

TX

99875

Special Handling

Thank you for your order!

[email address removed]

N

Y

0.02

Y

Gift Cards

2

5

TAX

102

Leonard Walker Inc

01/10/2020

Checking

Cash

paid cash

9 Winding Road

Winchester

NY

12345

9 Winding Road

Winchester

NY

12345

Thank you for your order!

[email address removed]

Y

N

Y

Handhelds

Portable Game Player

1

100

TAX

then use an importer tool

https://get.transactionpro.com/qbo

Topics

Training

Community

Resources

How to mass import sales receipts