Ho to see how much paid to a customer
I need to itemise money donated to various charities throughout the year. I can get a total for my Charities category, but how do I see individual amounts donated per charity (or paid per customer)?
Forum Discussion
If you want to see how much has been paid to a Supplier, and you have entered each transaction as a Purchase (created a bill) from the various suppliers, you should be able to retrieve that information by using the Purchase Register Report. Put in your date range, and select each supplier you want the transactions for.
If the transactions were put in as Spend Money (and you have a little familiarity with using spreadsheets), I would go to the General Ledger report, enter the date parameters and just select the Charity Donation category (account). Once the report is run, click Expand All, then export it to Excel. Once it opens in the Excel spreadsheet, you can then set up column filters, and in the column "Transaction Description", just filter for each different charity (this assumes you have their names in that field in the first place). You can do a subtotal sum of the amounts for each filter you run.
If not adept with spreadsheets, maybe phone a friend?
