Solved

Undeposited Funds and Statement of Cash Flow

Forum|Forum|7 years ago
December 3, 2018
3 replies
0 views

Hi,

My general question is that I'm wondering why Undeposited Funds does not show as an adjustment to Net Income on the Statement of Cash Flow?

For some background context, we use QBO to manage the finances for our e-commerce company. A sale on our store creates a sales receipt with a deposit to undeposited funds. Shopify will remit aggregate funds to our bank once per week. When I reconcile the bank statement, I split/match the bank deposit to the corresponding sales receipts and create the appropriate balancing entries (for payment processing fees).

Overall this process works well, however, when I was trying to tie the balance sheet and statement of cash flows together, there is no adjustment for undeposited funds. This seems odd to me because these sales receipts are included in Net Income, without an adjustment for cash that isn't actually available, the statement of cash flow is overstating true cash.

Is there a way to change this to have Undeposited Funds as an adjustment? Or should I look to change my set up of Shopify Sales --> Quickbooks Sales Receipts?

Thanks,

Jake

QuickBooks Online

Best answer by qbteachmt

Undeposited Funds is part of Banking. It is never income or expense, but money Not in the bank. You've taken possession of it, and are sitting on that fat envelop, for you to take to the teller at the end of the day, for example. Or, you are holding it until the banking download shows it is in Checking. Or, it is showing funds from CC sales waiting to be settled to Operation Checking, from the merchant account Provider.

So, that is never income or expense; it's the step After sales has happened. It's simply a Division of your total funds: some in Checking, some in the Safe, some in Petty Cash, and perhaps some In Transit (Undeposited Funds) but you are considered to have Construction Receipt = it's technically Yours, already.

Never confuse Banking and Income. The Banking is Cash Flow, but not income or expense.

M

mazar

Hello,

Undeposited Funds is still an asset to your company so it represents real money you've collected, you just haven't deposited it in the bank yet. (Think the blue bag of 50's and checks you keep under your register drawer or the safe you keep in the back office to hold money before you do weekly bank drops)

I always recommend setting up QuickBooks to mimic as close as possible to whats happening in real life. If in real life Shopify deposits the money into your bank account then I would recommend adjusting your Shopify QBO sync settings so it deposits the money into the bank account on the sales receipt instead of Undeposited Funds.

qbteachmtAnswer

Undeposited Funds is part of Banking. It is never income or expense, but money Not in the bank. You've taken possession of it, and are sitting on that fat envelop, for you to take to the teller at the end of the day, for example. Or, you are holding it until the banking download shows it is in Checking. Or, it is showing funds from CC sales waiting to be settled to Operation Checking, from the merchant account Provider.

So, that is never income or expense; it's the step After sales has happened. It's simply a Division of your total funds: some in Checking, some in the Safe, some in Petty Cash, and perhaps some In Transit (Undeposited Funds) but you are considered to have Construction Receipt = it's technically Yours, already.

Never confuse Banking and Income. The Banking is Cash Flow, but not income or expense.

J

jgkirsch91Author

I think I understand now. So when I think about tieing together the Statement of Cash Flow and the Balance Sheet, I start with the "Cash" accounts at end of period_0, add net cash flow for period_1 and arrive at ending cash for period_1. This should be equal to the sum of "cash" accounts on my balance sheet.

I think where I went wrong was thinking the "Cash" accounts were just the Banking Accounts, but it's actually Banking + Undeposited Funds + Petty Cash + etc.

qbteachmt

You start with total Cash at the beginning of the reporting period.

Then, changes in other balance sheet accounts that used or provided funds, such as: a Loan Balance went down when you used Cash to make that payment; your AR went Down = you got Paid, so that increased funds. The Destination or Repository of those funds is any "stash of funds" you manage, including UF, if that is Not at 0. Or, you took a new loan = money got deposited in the bank. Or, you bought Inventory, so cash went down but Assets Total didn't change.

= ending Cash (cash and cash equivalents, really) at the end of the reporting period.

L

LH32

I was paid by the customer on the 23rd. The money still shows not deposited into my bank account.

C

ChristieAnn 11

Hi there, LH32.

Thank you for posting here in QuickBooks Community. I'll provide information about the funding time and how deposit acts in QuickBooks Online.

If you're using QuickBooks Payments, you can check in your account if the money paid from the customer is already deposited from there. This way, you can check the status of all your processed payments and, when we put them in your bank account and the totals. Then, the Merchant Service Center shows the deposit status Pending if the bank didn't clear the deposit yet. However, when Intuit receives information from your bank that the deposited funds have cleared, the status changes to Funded.

Here's how:

Sign in to the Merchant Service Center.
From the homepage, select Activities & Reports and then Deposits.
Select the date range in the Dates field.
Select Search.

Once verified that the amount is already deposited, you can record or make a deposit in QuickBooks Online. This is to make sure that the said payment hits your bank account. You can open this article to see further details and how to perform the steps: Record and make bank deposits in QuickBooks Online.

However, if the payments are still not yet deposited from the merchant and the customer pay online via credit card, the estimated time for payments to deposit is 5-7 banking days. While ACH payments will take a bit longer during your first month. You'll get your payments within 5 days for the first 1 to 4 weeks. For additional information, you can click this article: Find out when QuickBooks Payments deposits customer payments.

If the payment is still not deposited within the given length of time, I'd suggest contacting our Merchants Services Support Team. This team is the best resource for such inquiries, as they're able to request account information. They can also verify the status of the payment too and investigate why it wasn't deposited into your account yet.

Please also refer to this article to see how QuickBooks Payments deposits work in QuickBooks Online: Common questions about payments deposits in QuickBooks Online.

Don't hesitate to post again here in QuickBooks Community if you have additional questions. I'll be right here to help. Have a great day!

Sign up

Login with SSO

Login to the community

Login with SSO