Skip to main content
C
CityHandyman
December 3, 2022
Question

VAT reports

  • December 3, 2022
  • 1 reply
  • 0 views

When running a VAT report there are deposits in amongst the invoices why and how to remove them?

 

When trying to sort the invoice numbers in order i select the "Sort" button and almost all the invoice numbers are in order except for one or two, thanks in advance for any help given

 

See screenshot attached to see the problems in reports

1 reply

MariaSoledadG
MariaSoledadG
December 3, 2022

Let's find out and review the deposits that you're seeing on the report so we can remove them, CityHandyman. 

 

Based on your screenshot, it looks like those deposits that are showing on the report are invoice payments. You can link them to keep your record more accurate and be able to sort them. To do so, locate the deposit entry in your bank register, and follow the steps below:

 

  1. Go to Bookkeeping and select Chart of accounts (Take me there).
  2. Find the account you deposited the payment to and select Account history.
  3. Find and select the correct deposit. Then select Edit.
  4. In the Add funds to this deposit section, find the deposit.
  5. Select the Received From ▼ the dropdown, and select the customer the deposit was from.
  6. Select the Account ▼ dropdown. Then select Accounts Receivable.
  7. Select Save and Close.

 

Then, apply the deposit entry as an invoice payment. Here's how:

 

  1. Select + New.
  2. Select Receive payment.
  3. From the Customer ▼ dropdown, select the customer’s name. This displays all unpaid and outstanding credits for your customer.
  4. In the Payment date field, enter the day you received the payment.
  5. In the Outstanding Transactions section, select the invoice you need to mark as paid.
  6. In the Credits section, select the deposit.
  7. Select Save and close.

 

Also, make sure there's an invoice for your customer when linking with the deposit. And that, you've recorded the payment through bank deposit and not through the Receive Payment option. However, if you're unable to link them and want to remove them instead. You can simply click the transaction on the report. This will route you to the actual transaction page and allows you to delete the deposit transaction.

 

On the other hand, invoices can only be sorted based on the dates not by invoice numbers. You'll want to export your report to Excel.  From there you can sort them according to invoice numbers. In addition, learn how to filter specific information so you'll be able to get the data you need most. I've added this article for your reference: Customise Reports In QuickBooks Online.

 

Keep me posted if you have any questions about VAT Reports. The Community is always here to assist your needs.

Terms & ConditionsAccessibility statement