Skip to main content
T
TonicSandra
January 21, 2024
Question

HELP... QBO and Acuity Scheduling integration. I have invoices that are paid but they are staying sat in my Undeposited Funds account and I don't know how to move them?

  • January 21, 2024
  • 2 replies
  • 0 views
I take payments through Stripe via Acuity Scheduling. People pay either as they book (invoice generated in quickbooks through integration), or they pay later, then once paid the integration updates the invoice as paid. A high majority of my invoices are not sitting in my Undeposited funds account on QBO, but there's about 20 or so that are paid but sat there. Do you know why they are there please and what I can do about them being there? 
Thank you 🙏

2 replies

A
ArielI
January 21, 2024

Hello, Tonic.

 

First of all, I'd like to inquire about the specific window or feature in QBO that displays undeposited funds transactions. Is this information located within the App Transactions tab?

 

The funds are still undeposited because they have not been deposited into the bank to show these payments in the bank register. To address this, I suggest creating a bank deposit in QBO to accurately reflect the funds in the bank register.

 

Additionally, I encourage reaching out to Acuity Scheduling integration for assistance with setting up the mapping correctly within the app.

 

Also, I would encourage you to reconcile your accounts every month. This ensures they always match your bank and credit card statements and detect any possible errors accordingly. For the step-by-step guide, you can check out this article: Reconcile an account in QuickBooks Online.

 

If you have further concerns about your undeposited funds, you can comment below and we'll respond to you as soon as possible.

T
TonicSandraAuthor
January 22, 2024

Hey Ariell, thanks for your reply. 

It is showing them in the Chart of accounts page on my computer. I’ve not looked on my app. 

 

Thing is, as Stripe processes my transactions, the amounts that enter my bank are minus the Stripe transaction fees, so I’m not sure how I would assign the invoices to the payments in my bank…. If I add them manually as a journal entry, will I duplicate things?? Also why are only some of the invoices there and not all of them? 

I’m wondering if the combination of Stripe and Acuity play well with QBO??? 

4
4Gal
January 22, 2024

@TonicSandra 

You can use a 3rd party connector to reconcile Stripe transactions into QBO.

T
TonicSandraAuthor
January 22, 2024

Hummm have you seen the cost of them?? They aren’t cheap and I’m not sure they are worth it just for that!

M
MirriamM
January 22, 2024

Hello there, TonicSandra.

 

There's no need to create a journal entry for the fee. Instead, you'll just have to add the fee as a negative amount when depositing the payment. By doing this, the downloaded transaction from Stripe will match the deposit into your QuickBooks Online account.

 

To record the fee via bank deposit, here's what you'll need to do:

 

  1. In the left menu, click the + New button.
  2. Choose Bank Deposits.
  3. You should see the payment you entered in the Select Existing Payments section at the top.
  4. Place a checkmark to select the payment you want to deposit.
  5. From the Add other funds to this deposit section, enter the amount of the bank service fee charged to you by the credit card company as a negative amount.
  6. From the Account section, select the Expense account you usually use in tracking bank fees.
  7. Verify that the deposit amount is correct and click Save.

 

That’s it! You're now able to match the deposit to the downloaded transaction from Stripe.

 

For future reference, here's an article you can check for the best practices when reconciling your account: Reconcile an account in QuickBooks Online. It also provides information on what to do when encountering challenges during the reconciliation process.

 

Keep me posted if you have any other QuickBooks Online concerns. I'm always here to help!

Terms & ConditionsAccessibility statement