I run a pet services business. I use a separate software package that allows me to do scheduling and at the end of the month I can invoice all of my customers with a single click based on the schedules for that month.
What am I trying to achieve? I would like to create a single summary invoice within Quickbooks at the end of each month and then match all of the separate clients individual payments to the one invoice. I can match them individually but wanted to know if I could select say 15 or 20 and match them in one go? Any ideas much appreciated.
I have the same scenario and I do what you have advised, but it applies to single transactions. I create a blanket invoice, then assign multiple payments from my bank feed to the invoice payment, tedious with about 35 entries - one for every day. I am looking for a way to do this in batch with selecting all relevant deposits and assign to the invoice payment at once. ~5 minutes tops.
I've seen some reference to bucketizing to unassigned payments and then moving in batch - I want to keep in sales and re-assign to the invoice at end of the month.
Let me show you how to Exclude downloaded transactions by batch:
Go to the Banking page and select the bank.
Click the For Reviewed tab and select all payments for the invoice.
From the Batch actions drop-down, click Exclude Selected.
Second, we can change the Category of each payment into Accounts Receivable and let’s make sure that the correct Payee is selected. Then, let’s add them by batch by selecting the payments that were already modified and from the Batch actions, click Accept Selected.
Once done, we can open the Invoice and click the Receive Payment button. Select the invoice to be paid and at the Credits section, click all the possible Deposits.