cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Lwhitty
Level 1

What is the best way to do a 2 year catch up for my client who sell items online with Shopify, Paypal, Google Pay and credit cards E-transfers and gift certificates?

She will also be tracking inventory.
3 Comments 3
JamesM4
QuickBooks Team

What is the best way to do a 2 year catch up for my client who sell items online with Shopify, Paypal, Google Pay and credit cards E-transfers and gift certificates?

Hello Lwhitty,

 

Welcome to the QuickBooks Community. I'll be happy to steer you in the right direction so you can continue to do the things you enjoy. QuickBooks is versatile program that enables you to get your work done faster. 

 

To get started, could you elaborate on what you mean by doing a catch up? Based on what you've shared, I recommend looking into third-party apps on our site by visiting www.apps.com. I suggest choosing an app that suits your business needs based on the app reviews and description. I'll also leave this question open in the Community so other members can chime in and share their advice. 

 

In the meantime, don't hesitate to ask other questions in the comments below. I've got your back.

4Gal
Level 11

What is the best way to do a 2 year catch up for my client who sell items online with Shopify, Paypal, Google Pay and credit cards E-transfers and gift certificates?

@Lwhitty 

Prepare your Sales Receipt data with the following template

RefNumberCustomerTxnDateShipDateShipMethodNameTrackingNumLocationClassBankAccountPaymentMethodPaymentRefNumberBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgCurrencyExchangeRateBillEmailToBePrintedToBeEmailedShipAmtShipItemTipAmtDiscountAmtDiscountRateTaxRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Leather CaseLeather Case210  TAX
101Janice Johnson01/10/2020     CheckingCheck20013110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!  [email address removed]NY    0.02  Y Gift CardsGift Cards25  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y HandheldsPortable Game Player1100  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y Software1 Year Warranty125  TAX
102Leonard Walker Inc01/10/2020     CheckingCashpaid cash9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!  [email address removed]YN       Y Extended Warranty1 Year Extended Warranty15  TAX
103Lisa Smith01/10/2020     CheckingCheck459119 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256  We appreciate your business!  [email address removed]NY         Gift Certificate$50 Gift Certificate150  NON

 

then use an importer tool to proceed

https://get.transactionpro.com/qbo

 

Trish_T
QuickBooks Team

What is the best way to do a 2 year catch up for my client who sell items online with Shopify, Paypal, Google Pay and credit cards E-transfers and gift certificates?

Hi Lwhitty,

 

I recommend speaking with an accounting professional or associate, for their expertise and best course of action.  It's important that you're able to successfully enter historical data and ensure your books are balanced.  

 

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

Need to get in touch?

Contact us