Skip to main content
P
prestigetilesgv
August 22, 2019
Question

What can I do?Finally changed over from another accounting system. The tech we deal with didn't check it & we have doubled up account payments. What can we do?

  • August 22, 2019
  • 1 reply
  • 0 views
It has stuffed our reconciliation, & has created a nightmare for us for the last two months. I don't know what to do I am at the end of my tether.

1 reply

RenjolynC
RenjolynC
August 22, 2019

I'd like to make sure we are on the same page, prestigetilesgv.

 

If you see the duplicate transactions in the banking section, then we can exclude them. This will clear up the unnecessary transactions showing up in your reconciliation.

 

Here's how:

  1. On the left panel, click Banking.
  2. Click the For Review tab, and put a check mark on the duplicate transactions.
  3. Click the Batch actions drop-down menu, and select Exclude Selected.

Once excluded, you can also delete the transaction when you go to the Excluded section.

 

On the other hand, if you want to delete an entire reconciliation, then you can check this article for the steps: How to unreconcile a transaction or undo a reconciliation.

 

Please don't hesitate to reply on this thread if you have any additional questions. Thanks.

C
crazy horse lady
November 3, 2019

I have also had the same issue, changed from one accounting software to another and had quickbooks set up by professional however now i have 80% doubled up payments on invoices.  Expenses that dont even show up in accounts and a BAS that looks like i should sell my car to pay for. Payments in my news feed that dont marry up with any invoices as all, let alone are even present on my bank statement.  Its a complete mess of false numbers.

One step at a time....

How do i remove odd payments?

then 

How do i create a report that only shows what i need to manually check off my bankstatement against invoices raised and paid in period.

How do i create a report to only show what i need to manually check off my bankstatement against expenses paid.

thanks

 

IamjuViel
IamjuViel
November 3, 2019

I can help you sort this out, @crazy horse lady.

 

You can exclude duplicate downloaded transactions from your account. Let's first compare your list of bank transactions with your bank statement. From here, we can determine the duplicate transactions.

 

Here's a short video on how to remove duplicates in your account: 

For step-by-step instructions, you can read through this article: Remove duplicate transactions or personal expenses from bank feeds.

 

Once completed, let's run your Transaction Detail by Account report. It contains a list of your transactions and total for each account in your chart of accounts.

 

To view report, here's how:

  1. Go to the Reports menu.
  2. Scroll down to the For my accountant section.
  3. Select the Transaction Detail by Account report.

You can use this to compare the payments you've received and the expenses you've spent. Also, you can match the manually added transactions with your downloaded bank transactions.

 

Here's how:

  1. Open the transaction to expand the view. 
  2. Review the “Records found.”
  3. Select the link next to each record to get more details.
  4. Review the “Deposit to” field on the forms.
  5. When you’re done, select Match.

You can refer to this article for more detailed instructions: Download, match and categorise your bank transactions in QuickBooks Online.

 

Feel free to click the Reply button if you have other questions. The Community and I are always here to help.

Terms & ConditionsAccessibility statement