cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
APC3
Level 1

Merchant card sales

As a retail store we accept cash and card payments. As the card payments go through our provider worldpay they enter the bank as day totals upto 3 days later. How do I match the money coming into my bank account with the sales? Do i need to redo all my sales receipts as daily rather than weekly? Or how do I split the weekly card sales totals to match the incoming worldpay. UK edition would be most appreciated.

1 REPLY 1
ReymondO
QuickBooks Team

Merchant card sales

Let me help you match these transactions in QuickBooks, @APC3.

 

We can split them since they are composed of multiple payments in a single transaction. Here's how:
 

  1. Select the left Banking menu and select Banking.
  2. On the For Review tab, select a transaction to open it.
  3. Select the Split button to open the Split Transaction window.
  4. Select a Category and enter an Amount for each category to assign to the transaction until the total amount matches the downloaded amount.You can select Add Lines to add more categories, Reset to start over, or, if necessary, the trash can icon to delete a row.
  5. Select Save and Add.

 

The transaction is assigned to all of the categories you specified, saved to your register, and moved from the For Review tab to the In QuickBooks tab.

 

For your second concern, there's no need to redo all of your sales receipts. You can still use the steps above to split those weekly transactions in QuickBooks. 

 

If you need more information about managing transactions downloaded from your bank or financial institution, the following articles can help:

 


That's it! Please let me know if there's anything else I can do to be of assistance. Keep safe!

Need to get in touch?

Contact us