I have 800 invoices that are overdue 0.01

Hello there, brandonlong. I can share information to help you fix overdue balances on your invoices to make sure accounting data are accurate.

In QuickBooks, the program is dependent on all the transactions received and real-life entries you've recorded from your Shopify account. With this, you need to record them as a bad debt and write them off. This ensures your accounts receivable and net income stay up to date. Then, apply these items to your invoices, so accurate balances are recorded in your file. To do this, create a bad debts expense account and item:

1. Go to Settings ⚙ and select Chart of Accounts.
2. At the upper right, select New to create a new account.
3. From the Account Type ▼ dropdown, click Expenses.
4. Under the Detail Type ▼ dropdown, choose Bad Debts.
5. In the Name field, enter “Bad debts.” Once done, hit Save and Close.

Then, create a non-inventory item as place placeholder for the bad debt. This is used to balance the accounting data. You can check out Steps 2 to 6 outlined in this article for more detailed insights: Write off bad debt in QuickBooks Online.

In addition to this, you may also have the option to create journal entries to rule out the overdue amount on your invoices. Post the transaction under an Accounts Receivable (A/R) account, then receive payments to zero out its balances.

For future reference, I'm including this guide to help you review downloaded online banking entries, so these always match your bank and credit card statements: Categorize online bank transactions in QuickBooks Online.

I'll be on this thread ready to back you up if you require additional assistance managing overdue balances on sales transactions. Just let me know anytime you need further help. Keep safe!

@brandonlong 

I wish I knew a better way to do this but, as far as I know, there is no way to do this in bulk.  If the number of customers is manageable, it shouldn't take too long.  I would start by setting up a bank 'Clearing Account' in QB.  Then, make a journal entry: debit an appropriate expense account or sales discount account and credit the newly-created bank Clearing Account for $.01 X # of overdue invoices.  Then, start receiving $.01 payments on the overdue invoices and deposit them to the Clearing Account.  When you're done, the Clearing Account balance will be $0 and the invoices will all be closed.