LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
woodlandguns@gma
Level 1

Hello…new to qbo for my new small biz. I utilize a third party credit card processor and need help with how to categorize each sale.

 
5 Comments 5
Fiat Lux - ASIA
Level 15

Hello…new to qbo for my new small biz. I utilize a third party credit card processor and need help with how to categorize each sale.

Did you send invoices to your clients or accept payments on your webstore?

 

LeizylM
QuickBooks Team

Hello…new to qbo for my new small biz. I utilize a third party credit card processor and need help with how to categorize each sale.

Hi there, woodlandguns. 

 

I can share some info on how you can categorize each sale in QuickBooks Online (QBO). 

 

If you send an invoice to the customer, the categorization of your sale depends on the affected account of the items used on the invoice. 

 

We'll need to review the invoice and make sure to check the affected account. Once done, you'll need to match it to the invoice from the Banking page. I'll show you how:

 

  1. Open the Banking menu, then go to Banking.
  2. Select the For Review tab.
  3. Search for the deposit, then click to open the transaction.
  4. Click on Find Match.
  5. You can filter the result by changing the data range.
  6. Pick the matching transaction, then hit Save.

 

However, If you did not send an invoice, you can categorize it to any sales account and refer it to the accountant. Doing so ensures you'll record everything correctly and avoid messing up your books.

 

For future reference, read through this article to learn about balancing your checkbook to match your QuickBooks transactions: Reconcile an account in QuickBooks Online

 

Please let me know if you need clarification about categorizing transactions in QBO. I'll be more than happy to help you. Keep safe and have a good one!

woodlandguns@gma
Level 1

Hello…new to qbo for my new small biz. I utilize a third party credit card processor and need help with how to categorize each sale.

Hi. We accepted payments in store via credit card. They come through my bank account as one big batch every couple of days from my 3 rd party processor.  Jus wasn’t clear on how to categorize - do I create a sales receipt for each customer.?

Charies_M
Moderator

Hello…new to qbo for my new small biz. I utilize a third party credit card processor and need help with how to categorize each sale.

Good day, woodlandguns@gma.

 

Yes, you can create a sales receipt and use credit card as your payment method if you haven't registered it on QuickBooks. Then combine them into a single large batch.

 

To do:

  1. Click + New.
  2. Select Sales receipt
  3. Choose the customer from the Customer dropdown. Note: If you haven't set them up in QuickBooks yet, select Add a new customer.
  4. Enter the sales info, such as the payment method.
  5. Enter line items for the products and services you sold.
  6. When you're done, select Save and send to email the receipt.

Here's an article that you might find helpful when matching and managing your downloaded transactions: Categorize and match online bank transactions in Categorize and match online bank transactions in QuickBooks Online.

 

You can always get back should you need help with banking. I'll be right here. Have a great day.

Fiat Lux - ASIA
Level 15

Hello…new to qbo for my new small biz. I utilize a third party credit card processor and need help with how to categorize each sale.

woodlandguns@gma 

You can prepare your Sales Receipts 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 utilize an importer tool to proceed.

https://get.transactionpro.com/qbo

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us