Thanks for returning to this thread, @safoglio. Let me clarify things to reduce your extensive time spent on data entry in QuickBooks Desktop (QBDT).
We can use recurring invoices instead of creating a single invoice for a more streamlined workflow, allowing us to match multiple invoices to the deposited payment amount in your bank using Advanced Mode in your bank feeds. As my colleague mentioned, please ensure that the bank account is connected to QBDT so that bank transactions can be automatically downloaded.
The deposited amount doesn't match the amount in an invoice transaction you entered because of the SE fees. When you go to the Banking page to match the invoice transaction and deposited amount, the amounts don't quite add up, yet they’re the same transaction. You can make an adjustment to resolve the difference.
Here's how to enter an adjustment to resolve the difference in a match:
- Find the deposited amount on the Banking page to match the entered invoice transaction.
- Choose the item, and once the row extends, click Find Match.
- In the Add/Match Transaction page, select the transaction to match.
- Scroll down and click Resolve the difference amount.
- Scroll to the bottom of the table. Then, click the Add new expense to record money spent; click Add new deposit for the received amount.
- Complete the fields in the table to add the adjustment.
- Click Save once done.
On the other hand, matching the imported report via an Excel file to multiple transactions in QBDT is unavailable.
Also, you can contact our QuickBooks Desktop Support Team for further help. Our support representatives are available to conduct screen sharing using the necessary tools.
Furthermore, you can check out this article if you encountered problems when reconciling accounts: Fix issues when reconciling in QBDT.
Please let us know if you need further assistance managing bank deposits or any other QuickBooks issues. Have a good one.
