Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
M
matt brand
October 3, 2019
Solved

Undeposited funds

  • October 3, 2019
  • 1 reply
  • 5 views

Hi team

 

I've recently started using quickbooks. All I'm really looking for it to do is track my income verses my expenses (for assisting my tax return ) and my VAT Returns. I've already linked it for MTD. 

 

So I only really need to put in all my invoices and all my expenses. I do not want to link it to my actually business bank account. 

 

I notice when I mark an invoice as 'paid' it goes into the 'undeposited funds' 

 

Is there any reason I cant just leave all my income in there? Or should I still move it to default bank account even though I don't want to link it to my actual bank account?

 

Also - when I record expenses (say I buy materials for a job) - it asks for the payment account I bought the materials from - should this be undeposited funds? (if that is where i leave all my income?) or should it be bank account? 

 

Does any of that matter for tracking my VAT returns and income verses expenditure? 

 

Thanks

 

Matt

 

 

Best answer by EmmaM

Hello Matt

 

You do not have to link the bank account in real life through the QuickBooks to record the income and expenses through the banking connection option.

However if in real life you have put the money into the bank then the best thing to do is to set up a chart of account to represent the bank account and then when you mark an invoice as paid in the drop down which shows as undeposited funds change that to the bank account chart of account you set up(steps included below)

 

Where it is an expense you can then select the same bank account chart of account. Unless the situation is you are not banking the money and using petty cash money in which case you can set up a separate chart of account called petty cash in the same way as below except in detail type select cash in hand and name it petty cash.The undposited funds is intended for use when it is something you will be banking at a later date.If it is something you will not be banking as income and will use to pay for expenses you can record income to petty cash and expense out from it.

 

To set up the chart of account go to accounting on the left>chart of accounts>new>in account type select cash at bank and in hand>in detail type select current(if it is a saving account select savings) >in name select the name of the bank>you can enter in an opening balance at the time you want to start recording banking transactions>save and close.

 

Any income you have already recorded to undeposited funds you can bank by going to the +symbol>bank deposit>just select the bank account in the account section in the top left>select the date>tick the payments in the payments included in this deposit section>save

 

 

Any questions at all on this feel free to reply back to this post

 

Emma

 

 

1 reply

M
matt brandAuthor
October 7, 2019

Anyone???

 

Help!!

E
EmmaMAnswer
Level 10
October 7, 2019

Hello Matt

 

You do not have to link the bank account in real life through the QuickBooks to record the income and expenses through the banking connection option.

However if in real life you have put the money into the bank then the best thing to do is to set up a chart of account to represent the bank account and then when you mark an invoice as paid in the drop down which shows as undeposited funds change that to the bank account chart of account you set up(steps included below)

 

Where it is an expense you can then select the same bank account chart of account. Unless the situation is you are not banking the money and using petty cash money in which case you can set up a separate chart of account called petty cash in the same way as below except in detail type select cash in hand and name it petty cash.The undposited funds is intended for use when it is something you will be banking at a later date.If it is something you will not be banking as income and will use to pay for expenses you can record income to petty cash and expense out from it.

 

To set up the chart of account go to accounting on the left>chart of accounts>new>in account type select cash at bank and in hand>in detail type select current(if it is a saving account select savings) >in name select the name of the bank>you can enter in an opening balance at the time you want to start recording banking transactions>save and close.

 

Any income you have already recorded to undeposited funds you can bank by going to the +symbol>bank deposit>just select the bank account in the account section in the top left>select the date>tick the payments in the payments included in this deposit section>save

 

 

Any questions at all on this feel free to reply back to this post

 

Emma

 

 

M
matt brandAuthor
October 8, 2019

Hi Emma

 

Thank you!!! You’re an absolute star that’s exactly what I needed. I never use cash I always use the card (bank account) to buy all my expenses and all my invoices get paid into that account too. So I think I will set up a ‘business bank account’ as you describe in QuickBooks. 

 

Can you help will expenses categories? I’m confused with what they mean. 99% of all my expenses are stock or materials for a job - what category should this come under? Some people say its ‘purchases’ whereas some tell me it should be ‘cost of good sold’ 

 

I can work out the insurance and things like office supplies :)

 

Really appreciate your help :)

 

Matt

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement