First Previous - Page 1 of 1 - Next Last

Quickbooks Problems - Cash Accounting - Deposits in the Customer Centre

  • Member PM.Dip
  • Practice Licence
  • 30 posts
  • # 109010

Dear All

In particular the ones that use Quickbooks Desktop.

One of my clients has got Quickbooks Pro 2013.

We have been having some nightmares with Quickbooks, because in my opinion Quickbooks is simply not designed for Cash Accounting.... I had several discussions with Intuit and that got me nowhere...

Anyway I would like to ask the following question:

I would like to ask why a customer is showing a Deposit in the customer centre when the transaction was paid into the undeposited funds and them transferred to the current account (using the make deposits Wizard) to which Amex charges were applied and deducted on the amount banked.... Lets say the client paid £10,000.00, £150.00 were Amex charges were deducted at source and banked £9,850.00. Why is this deposit showing in the customer account in addition to the £10,000.00 payment from the customer, when the same procedure was used other clients and the deposit is not showing there.

I cannot see anything that could cause this. In the audit trail I can see that on that particular deposit the deposit line has got the client name, whereas no other deposits show the client name in the deposit line? What would the user need to do to make sure this is displayed in the customer centre, so I can try to replicate this, and make sure that procedure is not repeated again....as it is causing confusion...

 

Thanks

  • 491 posts
  • # 109023

Hi Carla

It sounds to me like one of the payments (the one that's not showing) has been 'accepted' into QuickBooks by using the 'Deposits' Window perhaps. This needs the Customer name to be entered in the Received From column and the 'accounts receivable' as the account. This tells QBs who the money was received from, so it knows to put the money there - but because it doesn't know anything else about the payment, it doesn't show in the Transactions panel.

The correct way to accept a payment is to go to Receive Payments, either in the Customer Centre, or from the Customers menu, then put the amount, date, undeposited funds or direct to the relevant bank etc. This will then show in the Customer Centre. If an invoice has been raised in advance of the payment, then it should be 'applied' to that invoice that will be showing in the Customer Payment window. If there is more than one invoice showing, make sure the correct invoice is selected. 

If the payment is a 'deposit' (i.e. an invoice may not have been raised yet) make sure that no invoices are selected before saving the payment. This way, it gets entered as a credit available. When the invoice is raised, then the payment needs to be 'connected' with the invoice. This is done by going to this Customer Payment screen again, making sure the payment amount is zero, select the invoice that has now been raised and clicking on the Discounts and Credits button, then ticking the relevant payment to make the invoice 'paid'. 

Just out of interest - In your settings, (Edit/Preferences/Payments/Company Preferences) have you 'unticked' the Use Undeposited Funds as default deposit account'? This then allows you to have the option of putting deposits direct to a bank account instead of having to use undeposited funds when it may not be necessary.

I hope this may help or give you something to check out.

  • 491 posts
  • # 109024

Hi again Carla

Another thing I've just realised is that you've said 'cash accounting' - so perhaps you're using, or should be using, sales receipts instead of invoices and payments.

With sales receipts, they enter the sale as a payment in one go (versus the invoice and payments as a 2 step process for accrual accounting). 

Again, the sales receipt (if the settings are set as per my last email) will allow you choose where to put the 'sale amount' - it can go direct to the bank, or to undeposited funds first if you wish, by putting this in the box at the top of the sales receipt. All sales receipts will show up in the Customer Centre Transactions panel.

First Previous - Page 1 of 1 - Next Last
bottomBanner
loading