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?

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.

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

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.

Thanks but that didn't help. I've now deleted all items as per the information/video and it hasn't made a difference.

I have also done the next two steps and still nothing.  Like i said, its a real nightmare.

I really need to speak with someone "verbally"as there are no Q&A relating to the problem i have.

Thanks for your help

Hi crazy horse lady,

You can run the Invoice List report to show the unpaid and paid invoices. This way, you can identify and delete those duplicate payments. Let me guide you how.

1. Click Reports on the left menu.
2. In the search field, type Invoice List.
3. Under Report period, click the drop-down arrow and select the date. 
4. Click Customize.
5. Click Rows/Columns.
6. Click Change columns.
7. Tick the A/R Paid and Account box.
8. Click Run report.

However, if you still need to contact our support team. Here how to reach them:

1. Sign into your account. 
2. Click Help on the upper-right corner.
3. Click Contact us.
4. Type your concern.
5. Click Let's talk.
6. Select Get a callback.

I have included this Help Articles in case you have other questions about QuickBooks Online (QBO).

Fill me in if you need further assistance. I'm always right here to help.