Limited time. 50% OFF QuickBooks for 3 months.
Buy now & saveJust learned that I should have made pledge invoices for a mission trip. My problem is that I have 6 months of transactions where I added the payment funds as deposits to a designated fund account under the General Fund.
I created the pledge invoices for each person today and added the payments as of today so each participant could see their balance due (not sent out yet). However, that created deposits to the Gen Fund, now have duplicated income. Some deposits were recorded in the last 3 months of last year and I don't want to mess last year's data. Do I have to go back to the original bank deposits and identify each one as a payment? I think that would mean I would have to backdate all of the pledge transactions I've added. Wouldn't that then automatically apply the payment to the invoice a second time? So then I would have to delete the payments I had added How do I clean this up?
Solved! Go to Solution.
We're here to make sure your income transactions are balanced, LARofTRA. We'll guide you through the process below.
To prevent duplication of income, yes, we'll have to go back to your original bank deposits and edit the affected account, changing it from Gen Fund to Accounts Receivable (A/R). Then, we'll apply them as payments towards your open invoices.
Before proceeding, you can turn off the Automatically apply credits option. By doing this, the system will not automatically apply the deposit after you have updated the account to A/R. This will save you the trouble of deleting payments to tidy up your income data. To do this, here's how:
After that, update the impacted account of your deposits from Gen Fund to Accounts Receivable (A/R). Then, link them to your outstanding invoices. For the complete guide, please see this article: Link a bank deposit to an invoice in QuickBooks Online.
Additionally, when you run a nonprofit organization, you can easily keep track of the money you receive from your donors in QuickBooks Online (QBO). You might consider checking out this article to learn more about this procedure: Record fund donations.
If you have any further concerns about managing income transactions in QBO, feel free to comment below, and we'll be happy to assist you.
We're here to make sure your income transactions are balanced, LARofTRA. We'll guide you through the process below.
To prevent duplication of income, yes, we'll have to go back to your original bank deposits and edit the affected account, changing it from Gen Fund to Accounts Receivable (A/R). Then, we'll apply them as payments towards your open invoices.
Before proceeding, you can turn off the Automatically apply credits option. By doing this, the system will not automatically apply the deposit after you have updated the account to A/R. This will save you the trouble of deleting payments to tidy up your income data. To do this, here's how:
After that, update the impacted account of your deposits from Gen Fund to Accounts Receivable (A/R). Then, link them to your outstanding invoices. For the complete guide, please see this article: Link a bank deposit to an invoice in QuickBooks Online.
Additionally, when you run a nonprofit organization, you can easily keep track of the money you receive from your donors in QuickBooks Online (QBO). You might consider checking out this article to learn more about this procedure: Record fund donations.
If you have any further concerns about managing income transactions in QBO, feel free to comment below, and we'll be happy to assist you.
Just to confirm, you previously recorded deposits and assigned the designated fund to those deposits, correct? If that's the case, set up a Service Product called 'Payment Received - XYZ Mission Trip' and select the same designated fund account under the 'Income account' drop-down that you assigned to the deposits. Then, add 'Payment Received - XYZ Mission Trip' to the 2023 invoices as a negative amount for the payments received. That will reduce the invoice balance due by the amount of the payments received and reduce the duplicate entries to the designated fund by a corresponding amount.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here