Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
TCOG
Level 1

Imputing individual giving amounts without duplicating entries

Hey guys, 

 

I need help with something on QuickBooks online. Our bank accounts and giving accounts are integrated with QuickBooks, so the donations come in 1 large lump sum. Is there a way to input what each person from my church donated without duplicating any entries? I've been trying to do this all day but nothing seems to work. Thank you. 

Solved
Best answer January 15, 2024

Best Answers
jenop2
QuickBooks Team

Imputing individual giving amounts without duplicating entries

Good to see you here, TCOG. I'm glad you reached out with this question about recording a lump sum deposit and allocating amounts to different donors.

 

The good news is there is a way to show how a single deposit should be divided across multiple contributors without duplicating entries.

 

QuickBooks Online provides a "Split" function that allows you to take one deposit and indicate specific amounts for each donor. 

 

I'd be happy to walk through exactly how to use Split to properly categorize a lump sum donation from various people. Here's how:

 

  1. Go to the For review tab.
  2. Select the downloaded transaction to expand the view.
  3. If the option in the Action column is Match, change the Find match to Categorize.
  4. Select Split next to the Add button.

 

This opens the Split transaction window. Then, proceed to these steps to divide the amounts: 

 

  1. From Category dropdown, select the categories (the accounts) you want to split the transaction into.
  2. Enter an Amount for each split.
  3. Select a Customer or Received From for each split.
  4. When you're done, select Apply and accept.

 

For more details on managing downloaded transactions, this Help article has additional tips: Categorize Online Bank Transactions In QuickBooks Online.

 

I also recommend bookmarking these other articles related to online banking in QBO:

 

 

Please don't hesitate to reach back out if you have any other questions working with bank feeds or transactions in QuickBooks Online, TCOG. I'm always happy to help explain how the feature works or provide troubleshooting for any online banking concerns.

View solution in original post

3 Comments 3
jenop2
QuickBooks Team

Imputing individual giving amounts without duplicating entries

Good to see you here, TCOG. I'm glad you reached out with this question about recording a lump sum deposit and allocating amounts to different donors.

 

The good news is there is a way to show how a single deposit should be divided across multiple contributors without duplicating entries.

 

QuickBooks Online provides a "Split" function that allows you to take one deposit and indicate specific amounts for each donor. 

 

I'd be happy to walk through exactly how to use Split to properly categorize a lump sum donation from various people. Here's how:

 

  1. Go to the For review tab.
  2. Select the downloaded transaction to expand the view.
  3. If the option in the Action column is Match, change the Find match to Categorize.
  4. Select Split next to the Add button.

 

This opens the Split transaction window. Then, proceed to these steps to divide the amounts: 

 

  1. From Category dropdown, select the categories (the accounts) you want to split the transaction into.
  2. Enter an Amount for each split.
  3. Select a Customer or Received From for each split.
  4. When you're done, select Apply and accept.

 

For more details on managing downloaded transactions, this Help article has additional tips: Categorize Online Bank Transactions In QuickBooks Online.

 

I also recommend bookmarking these other articles related to online banking in QBO:

 

 

Please don't hesitate to reach back out if you have any other questions working with bank feeds or transactions in QuickBooks Online, TCOG. I'm always happy to help explain how the feature works or provide troubleshooting for any online banking concerns.

TCOG
Level 1

Imputing individual giving amounts without duplicating entries

That worked! Thank you so much for your help! 

Carneil_C
QuickBooks Team

Imputing individual giving amounts without duplicating entries

Hello, @TCOG.

 

On behalf of my colleague, jenop2, you're welcome. It's good to know that the resolution provided above worked for you. The QuickBooks Community will always be around to lend you a hand any time you need guidance.

 

I'll be around if you need further assistance with any QBO-related tasks. I hope you have a pleasant day ahead. Keep safe always!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us