Skip to main content
G
gerdgoebel
February 8, 2024
Question

Report my charitable donations

  • February 8, 2024
  • 1 reply
  • 0 views

I am still using QBD 2020 Prem.

I found this article about handling donations of products and services.

 https://quickbooks.intuit.com/learn-support/en-us/help-article/accounting-bookkeeping/record-donations-charitable-contributions/L1Z85Y1Ta_US_en_US?uid=lscyh4oo

 

I already had an expense account for my Charity/Donations, I created an inventory item which the sales income account pointing to the charity/donation expense account.

I created an invoice for my donation of product and created the credit memo for it and linked it to the invoice. Invoice shows paid.

My problem is the reporting. Where do I see the total donations I have done throughout the year? Profit and Loss shows 0 on the Charity/Donations account. As well as my sales by item summary.

I am looking for a report that shows the amount of my donations for my accountant.

 

1 reply

G
GenmarieM
February 8, 2024

Hello there, @gerdgoebel.

 

I am here to share some insights into running a report for your donations in QuickBooks Desktop (QBDT).

 

It's important to note that when you create an invoice for your inventory item as a donation, it will be reflected in the Profit and Loss report. However, it's crucial to check the dates and filters applied to your report. In case you find that the donations are not showing up, it's recommended to review and erase any previous filters that might be obstructing the report. This will help you to obtain a clear report without any filters.

 

After deleting the previous filters, you can customize reports and add new filters to find the donations easily. 

 

Here's how:

 

  1. After opening the Profit and Loss report, go to Customize reports.
  2. Click on the Filters tab.
  3. In the Account, select the account you put your donations to.
  4. Click OK.

 

You'll be able to see all the donations on that specific account you used for your donations.

 

Moreover, I'm adding this helpful article as your reference in memorizing your reports in QBDT: Create, access and modify memorized reports.

 

Return to this post if you have other concerns about running financial reports in QBDT. I'll be here to lend a hand. Have a good one!

G
gerdgoebelAuthor
February 8, 2024

Thanks for your reply,

but this is not a filter problem, as I use the standard profit and loss report and I don't use a filter for this report

also, if you check the instructions I had linked, we first create an invoice for $80 (as example), posting to the expense account Charity/Donations. The balance now is $80.

But then we create the credit note for the same amount with the same line items which also posts against the same Charity/Donations account, thus, making the account 0.

 

G
GebelAlainaM
February 8, 2024

Thanks for your reply, gerd.

 

I appreciate you following the article you shared in this thread. Let me share additional information about your concern about pulling up reports for your charitable donations. 

 

In QuickBooks, if you create an invoice with the amount of $80 and link it with a credit memo that also amounts to $80, it will automatically zero out the invoice balance and mark it as paid. 

 

Moreover, the Profit and Loss report tells you how much money you’re making and how much you’re losing. So, it's normal that the balance for the Charity/Donations account will be zero since the invoice was paid when you linked the credit memo. 

 

If you want to pull up a report that will only shows all the invoices that you created for your charitable donations, you can pull up the Sales by Customer Detail report and customize the accounts and transactions. 

 

Here's how:

 

  1. In the Reports menu report, locate the Purchases by Item Detail.
  2. Select Customize Report.
  3. Click the Display tab.
  4. Under the Columns section, select Paid.
  5. In the Filter section, search for Account and choose Charitable Contribution or the account you use for the donations.
  6. Then, hit OK.

 

Furthermore, you can also reach out to your accountant for another way to run reports for contributions and managing your charitable donations.

 

To learn more about running and customizing reports in QBDT, you may check these articles:  

 

 

Please feel free to post again if you have follow-up questions or additional query. I'll be around to help you.

Terms & ConditionsAccessibility statement