Skip to main content
July 18, 2022
Question

How to do a bulk G/J entry for an entire year of Square Merchant Fees without raising Income the same amount?

  • July 18, 2022
  • 1 reply
  • 0 views

I am working on fiscal year-end taxes for our C Corporation. We DO NOT use banking feed nor invoicing through QB Desktop Pro Plus 2022. Square is our current vendor for processing CC payments. They report our Gross Income to the IRS via a 1099-K. We manually add deposits (Net Sales after Square has removed their fees) in a lump deposit a few times a week. Each deposit represents numerous customers from a day.

 

PROBLEM When I try to make a G/J entry to record an entire year of Square's Merchant Fees (Expense) by debiting the Merchant Fees Expense Account and crediting either Sales or Deposits (Income), then the Gross Profit figures on my P/L sheet obviously rise the same amount.

 

I need our Gross Profit to stay as it is, which is accurate. This is the actual revenue reported to the state every month.

 

QUESTION 1: How do I make ONE G/J entry to record an entire year of Square Merchant Fees WITHOUT changing the Income/Sales/Total Income/Gross Profit at all? Does anyone know? Perhaps it's not a "balancing" or "offsetting" G/J entry I'm looking to do because Merchant Fees WERE collected from our customers but WERE NOT actually deposited in our bank account? But by raising our Gross Income the same amount as the Merchant Fees that Square took and never hit our bank account, it seems like we're having to pay Federal taxes on Gross Profit that would then be inaccurate.

 

Further and going forward this year, when I record a deposit manually showing the amount collected from customer, then adding Merchant fee as a - (minus), and the Deposit Subtotal and Deposit Total both become the actual amount deposited, BUT THIS UNFORTUNATELY also raises our Gross Profit inaccurately as well. Our only profit comes from labor and parts. Retail sales taxes go to the cities and the state and Square takes their fees out of our deposit before it hits the bank. QUESTION 2: How do I accurately manually record each lump sum/bulk deposit, while also recording the lump sum/bulk Merchant Fees taken out by Square, without elevating our Income/Sales/Gross Profit inaccurately with each deposit?  

 

Sorry for length. This is very puzzling and four people on the phone from QB Support could not help me. I've been trying to figure this out for nearly 2 weeks. Bah! Can anyone here who is adept at QB Pro-land help me? 

1 reply

info868Author
July 18, 2022

I'm going to try my question another way: 

 

Can I credit Undeposited Funds and debit Merchant Fees the same amount to record a whole year of CC processing fees deducted from our Gross Sales? When I do this G/J entry, the Profit & Loss and Balance Sheet all appear accurate!

 

If I can do this, how then do I do a follow-up G/J entry to remove/delete/cancel this one ^ so that the Fixed Assets or Bank Account balance is accurate for the start of the new Fiscal Year? 

 

My goodness. Please help me if you are able. My head hurts.