Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowSolved! Go to Solution.
Thank you for the response. After much prayer and playing around with it, I was able to find the best approach:
1. After adding the Customer, I used the Project tab to create an invoice for the PY grant. The invoice date & due date was 12/31/19. I created a new Product/Service of Beginning Grant Balance so I could track/see these balances separately if I ever needed to do so. The balance of the invoice was the beginning balance of the grant. This steps created an A/R and the other side of the transaction is to Net Assets.
2. Once the invoice was created, I received payment for the same amount of the invoice. The payment date was 1/1/20. This eliminated the A/R that was created in step 1 and increased the balance of the respective cash/bank accounts.
3. Since I had already added the beginning balances of the cash/bank accounts, I had to create a J/E to reduce the cash/bank accounts to the correct balance and debit the Net Asset account.
4. Finally I verified that my Opening Balance of Net Assets account tied to my 12/31/19 statements.
Good day, cqhuynh,
You can enter the starting balance in the Donor's Opening Balance. And use it for future projects.
Here's how:
Check these articles for future reference:
Stay in touch with me if you have other questions.
Thank you for your response. Entering the beginning balance as instructed on the Customer screen results in a receivable and income being recorded in the current year. The grants were received in the prior year and met the NPO requirements to be recognized as revenue in the prior year, so I am unsure how to use the Customer and/or Projects feature without overstating income. We have several grants and I would like to track them using QuickBooks to avoid having to maintain a separate spreadsheet. However, I am wondering if the feature will even work for grants that carryover to the next fiscal year.
I am open to any other suggestions.
Thanks so much!
Thanks for your prompt response, @cqhuynh.
I'd suggest checking the dates and make sure that these transactions are posted on the prior dates that it was created instead of this year.
This way, the receivable and income won't be recorded in the current year.
I'll be adding this article for more details about tips on how to work on with Projects in QuickBooks Online:
Just in case you wanted to run report with your projects, you can go to the Projects menu and then select the project name. Then go to the Project Reports tab and select Project profitability.
You can cling with us always if you have further concerns. I'll keep my notifications open. Have a good one!
Thank you for the response. After much prayer and playing around with it, I was able to find the best approach:
1. After adding the Customer, I used the Project tab to create an invoice for the PY grant. The invoice date & due date was 12/31/19. I created a new Product/Service of Beginning Grant Balance so I could track/see these balances separately if I ever needed to do so. The balance of the invoice was the beginning balance of the grant. This steps created an A/R and the other side of the transaction is to Net Assets.
2. Once the invoice was created, I received payment for the same amount of the invoice. The payment date was 1/1/20. This eliminated the A/R that was created in step 1 and increased the balance of the respective cash/bank accounts.
3. Since I had already added the beginning balances of the cash/bank accounts, I had to create a J/E to reduce the cash/bank accounts to the correct balance and debit the Net Asset account.
4. Finally I verified that my Opening Balance of Net Assets account tied to my 12/31/19 statements.
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.