Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
One of my clients also has a non profit ministry also. They make a donation to a school in south america. The school sends them an "expense report" each month. Is there a way to track their charitable contributions and also the expenses in QBO? We list the donation as a chartiable contribution, but would also like to compare what we are sending them to what they are spending to what we are donating. That we would be able to see any unusual expenses.
Greetings, @LRBookkeeping.
I can guide you in tracking your client's charitable contributions in QuickBooks.
You can set up the charitable organization you're donating to as a vendor. Then, you can create a Charitable Donation item and use it in creating a check or a bill and payment, just as you would for any other payment to a vendor. Let's first create a Charitable Donations expense account.
This specific account is used to track expense transactions for tax-deductible contributions, as this will make things easier for your accountant or tax preparer. Now, let's create the Charitable Donations service item.
One everything is set up, you can now create a check, an expense transaction, or a bill every time they make a donation. You can check this article for more detailed information: How to record donations or charitable contributions.
Lastly, you can customize and generate the Transaction Detail by Account report. This will display your charitable donations-related transactions.
Always feel free to leave your comments below if you have other questions about tracking your non-profit related transactions. I'm always here to help.
So my client is the non profit. We track contributions to us. And we track donations made.
We receive donations slotted for a school in another country. (Contribution in as Non profit income) We fund the school monthly. ( Expensed out as Charitable Contributions). The school sends us a spread sheet each month with what they spent the money on. Is there a way to track that spreadsheet in quickbooks? So we can see what areas the money is being spent on?
I'm here to help you track the spreadsheet sent to you in QuickBooks, @LRBookkeeping.
If those are bank transactions, you can import them through a WebConnect or CSV file into QuickBooks Online (QBO). You may use either a 3-column or 4-column format. Then, categorize the transactions as donations and expenses.
Once your CSV file is ready, refer to the steps below to begin the import:
Here's the article that will provide more info about the process: Import bank transactions using Excel CSV files.
Also, you may check out this wonderful article to help you review your accounts to ensure they match your real-life bank statements: Learn the reconcile workflow in QuickBooks.
Please know that you're always welcome to post again if you have any other concerns about tracking your data. I'm always here to help. Wishing you and your business continued success.
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