Generating reports in order to make a Gift Aid Tax Reclaim

Sanshin · ‎July 22, 2024

We are a registered charity and exist entirely on donations, which may come by bank transfer directly into our account, but also regularly in cash or by cheque, which we send to our bank with multiple other amounts. We record these amounts in QB as a deposit split into these multiple items. I would like to be able to generate a report - specifically for a Gift Aid Tax Reclaim, that shows these individual amounts. We have found a way of generating a report, by filtering the relevant income accounts, that shows all individual transactions, but have not found a way of including all relevant items in a deposit which is split into multiple amounts. Those amounts remain hidden. Please could you help with this.

Making a Gift Aid Reclaim on QB Desktop was very straightforward; it doesn't seem to be so easy on QBOnline.

We tried using one of the reports on the list 'For my Accountant' and the report showed no data. Any suggestions you have would be welcome.

ShaniamarieC · ‎July 22, 2024

Hi @Sanshin! You're in the perfect spot to get help with generating reports for Gift Aid Tax Reclaim in QuickBooks Online (QBO).

To generate a report that shows relevant items in a deposit that is split into multiple amount, you can run either the Transaction Detail by Account or Deposit Detail report and customise them to the bank account used for that transaction, and its type (e.g. Deposit).

Let me guide you how:

At the left navigation panel, click Reports.
You can choose which report to view either Transaction Detail by Account or Deposit Detail then type in the search bar
Change the Report period specific to the date you created the Gift Aid Tax Reclaim transaction.
Click on Filter. Filter by (Account), Options (choose at the dropdown below) then, Value (pick the Account used for that transaction).

Here's a photo for your reference:

We'll share these articles so you can get the most out of your financial reports:

I’ll be around the corner if you need an extra pair of hands in any QuickBooks-related matters, @Sanshin. Stay safe!

Topics

Training

Community

Resources

Generating reports in order to make a Gift Aid Tax Reclaim

Generating reports in order to make a Gift Aid Tax Reclaim

Need to get in touch?