Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
LARofTRA
Level 1

Just learned that I should have made pledge invoices for a mission trip.

Just 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
Best answer March 18, 2024

Best Answers
Rea_M
Moderator

Just learned that I should have made pledge invoices for a mission trip.

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:

 

  1. Go to Settings, then select Account and settings.
  2. Select the Advanced tab.
  3. Click Edit ✎ in the Automation section.
  4. Turn the Automatically apply credits option off to decide which open invoices you want to apply the deposit to.
  5. Select Save, then Done.

 

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. 

View solution in original post

2 Comments 2
Rea_M
Moderator

Just learned that I should have made pledge invoices for a mission trip.

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:

 

  1. Go to Settings, then select Account and settings.
  2. Select the Advanced tab.
  3. Click Edit ✎ in the Automation section.
  4. Turn the Automatically apply credits option off to decide which open invoices you want to apply the deposit to.
  5. Select Save, then Done.

 

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. 

Rainflurry
Level 14

Just learned that I should have made pledge invoices for a mission trip.

@LARofTRA 

 

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.  

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up