Skip to main content

How to View and Export Donation Data?

Want to see who donated and how much? You can view a summary directly on the website or download a full report to Excel


How can I access information about donations and donors for the charity?
On the Jgive website, you have two primary methods for accessing this data:

Donations Page:

The detailed donations table — filter, choose columns, download a full Excel report and receipt copies.
​
​The "Analytics" dashboard: a graphic overview of your whole fundraising — summary cards, charts and filters (details below).


Viewing the Donations page

1. Access the charity area: click your profile picture in the top-right corner of the site, then click your charity's name in the menu that opens.
​

2. Click Donations in the side menu on the left side of the screen.
​

On the donations page, you can explore general data about donations and donors to the charity, including information such as the donation date, donor name, donation amount, and more.

If needed, you have the option to edit the target, endowment, or share details of the donations. Additionally, you can access further data related to your monthly donations by visiting the 'Recurring Donations' tab at the top of the page.

Above the table you'll find the filter bar: Donors, Campaigns, Payment method and Period. Click Add filter to filter also by currency, campaign type, donation type and dedication. Click Download to get an Excel file of all the donations that match your filters.
To download a receipt copy, click the receipt icon in the Receipt column (can't see it? scroll the table sideways). The donor's email is in the Donor Email column; add payment method, donor phone number and more with the Columns button. Actions on a donation (such as Move or View/Edit Comment) are in the actions menu (⋮) of its row.
​
​

*Important Note: Do not utilize the email address of donors without their explicit consent. You can check whether donors have agreed to be contacted by referring to the "Donor Share Info" column in the donation table.


Downloading the full donations file

1. In the charity area, click Analytics in the side menu.
​

2. Filter the data you need: Period and Payment method, and with Add filter also campaigns, currency, donors, campaign type, recurring donations and more. The file includes only the donations that match your filters.

3. Click Download above the data cards, next to Compare.
​

4. Wait for the file to be ready (for large files this may take a few minutes). When it is ready, it downloads to your computer automatically.

We suggest using Google Sheets to read the file (click here for a sheet import guide), although any other software you have, such as Microsoft Excel or Open Office Calc, will work as well.

Inside the file, you will find a table with the data on donations and donors. Below are the main columns in the file, in column order:

Data

Explanation

Column

Donation Type

Donation type

A

id

Donation ID

B

Transaction Date

Donation Transaction Date

C

Amount

Donation Amount

D

Releasable Amount

Donation amount minus fees

E

Currency

Donation Currency (USD, ILS, CAD, GBP)

F

Amount (ILS)

Donation amount in ILS (converted)

G

Target Name

Campaign Name

H

Target ID

Campaign ID

I

Main Event ID

Main Campaign ID (Relevant for Ambassador Campaign)

J

Team ID

Ambassador Team ID (Relevant for Ambassador Campaign)

K

Donor First Name

Donor First Name

L

Donor Last Name

Donor Last Name

M

Invoice Recipient Name

Name on the Receipt

N

Donor Email

Donor Email

O

Donor Phone Number

Donor Phone Number

P

Donor Israeli ID

Donor Israeli ID

Q

Recurring

Recurring (Yes/No)

R

Recurring Months

Recurring Months

S

Recurring Ends At

Recurring End Date

T

Payment Provider

Funds Processed Through (Jgive, Stripe, PayMe, Meshulam)

U

Payment Method

Payment Method (CreditCard, DAF, Wire, JCF, BIT, Check, Wallet)

V

Payment Redirected

Donations Redirected by Jgive Fund (Consolidated on 20th of the month)

W

Card Last 4

Last 4 Digits of Credit Card

X

Card Brand

Credit Card Company

Y

Wallet Type

Digital wallet type (Apple Pay / Google Pay), if a wallet was used

Z

Processing Fee

Processing Fee

AA

Market Fee

Platform Fee

AB

Transaction Fee

Fixed Fee of 30 Agorot

AC

Release Status

Status of the funds transfer to the charity's bank account

AD

Released At

Funds Transfer Date

AE

Release Date Conversion Rate

Currency conversion rate on the funds transfer date (foreign-currency donations)

AF

Comment

Donor Dedication/Comment on the Donation

AG

Foreign Card

Is it a Foreign Credit Card? (Yes/No)

AH

Share Donor Details

Did the Donor Choose to Share Their Details with the Organization? (Yes/No)

AI

Donor Foundation Name

Donor foundation name (if entered)

AJ

Receive Updates

Does the Donor Want to Receive Updates from the Organization? (Yes/No)

AK

Share Donor Name

Did the Donor Choose to Share Their Name on the Site? (Yes/No)

AL

Share Donation Amount

Did the Donor Choose to Share the Donation Amount on the Site? (Yes/No)

AM

Hidden (For Offline)

Is the donation hidden from public display (offline donations)? (Yes/No)

AN

Invoice Issued

Was a receipt issued for the donation? (Yes/No)

AO

Invoice Number

Receipt number

AP

Invoice Copy URL

Link to the receipt copy

AQ

Tax Authority Confirmation Number

Tax Authority confirmation number for the receipt

AR

Transaction Voucher

Transaction Code from the Credit Card Company

AS

Is Negative

Is it a Refund? (Yes/No)

AT

Chargeback

Is it a Chargeback not Done by Jgive (By the Customer/Credit Card Company)?

AU

Refunded At

Donation Refund Date

AV

Withdrawal Code

Withdrawal Code - a Unique Code Transferred to the Organization when it Receives Funds from the Credit Card Company

AW

Withdrawal Date

Date of Funds Transfer by the Clearing Company

AX

Provider Payment ID

Payment Provider ID

AY

Question 1

Question 1 (In the Donation Process)

AZ

Answer 1

Answer to Question 1

BA

Question 2

Question 2 (In the Donation Process)

BB

Answer 2

Answer to Question 2

BC

Question 3

Question 3 (In the Donation Process)

BD

Answer 3

Answer to Question 3

BE

Question 4

Question 4 (In the Donation Process)

BF

Answer 4

Answer to Question 4

BG

Question 5

Question 5 (In the Donation Process)

BH

Answer 5

Answer to Question 5

BI

Question 6

Question 6 (In the Donation Process)

BJ

Answer 6

Answer to Question 6

BK

Purpose ID

Purpose ID Chosen in the Donation Process (If Any)

BL

Purpose Title

Purpose Title Chosen in the Donation Process (If Any)

BM

UTM Parameters

UTM Parameters (If Any)

BN

Is Embedded

Is the Campaign Embedded? (Yes/No)

BO

Donor Covered Fees

Did the Donor Cover the Fees Instead of the Organization? (Yes/No)

BP

Donor Covered Fees Amount

Fee amount covered by the donor

BQ

Igul Letova

Did the donor choose Igul Letova (rounding up the donation)? (Yes/No)

BR

Igul Letova Card Brand

Card company used for the Igul Letova charge

BS

Match Request ID

Match Request ID by Employer/External Entity to the Organization

BT

Match Request Status

Donation Matching Status (Pending, Matched, Failed, Cancelled)

BU

Sent By Check

Was the Donation Sent by Check? (Yes/No)

BV

Donation ID

Additional internal donation ID

BW

Matching Index

Donation matching index

BX

Matched Amount

Matched amount approved for the donation

BY

Kindly note that the file includes additional columns, and the order of these columns may change periodically.


Choosing columns in the donations table

You decide which columns the table shows:

  1. Click "Columns" above the table.

  2. Tick the columns you want — for example payment method, donor phone number, matching amount and receipt. You can also search for a column.

  3. "Show/Hide all" toggles everything at once, and "Reset" restores the default.

The base columns (donor name, amount and charge date) are always shown.


The "Analytics" dashboard — your overview

In short: the "Analytics" page shows your whole fundraising picture at a glance — no export needed.

  1. Log in to the charity area and click "Analytics" in the side menu.

  2. At the top you will see summary cards: total raised, average donation, median donation, highest donation, number of donations, unique donors and campaigns.

  3. Scroll down for charts: breakdown by currency, campaign type and payment method — plus donations over time.

Filtering the data:

  • Period — defaults to the last week. Multi-year ranges switch the time chart to a yearly view automatically.

  • Payment method — including cash.

  • Donation type — regular or offline.

  • Recurring — all / recurring only / exclude recurring.

  • Exclude matching — show the numbers without matching donations.

  • Add filters — filter by campaigns and more. Type a campaign name — the closest matches appear first.

  • Country — filter by the country donations came from, using the address the donor gave at checkout. When you pick United States, a State filter appears too.

💡 Country, state and city show only for donors who agreed to share their details. A donor who did not agree appears under Not specified.

💡 While a country, state or city filter is on, offline donations are not counted, because they have no address.

In multi-select filters, tick the options and click "Apply" — the data refreshes in one go.

💡 You can also click a chart segment (e.g. a currency or payment-method slice) — it is applied as a filter to the whole page.

💡 The page also shows your recurring donations potential — the projected future income from your active recurring donations.

How do I choose which campaigns appear on the chart?

  1. The Top Campaigns table now pages through every campaign active in the period — five rows at a time.

  2. Each campaign has a checkbox: tick the ones you want to see on the chart.

  3. You can plot up to five campaigns at once. The first ones are ticked automatically.

  4. Reached five? The next checkbox is disabled with an explanation — untick another campaign to free a slot.

  5. Every ticked campaign keeps a fixed colour dot in the table, matching its line on the chart.

How do I compare with another period?

In short: click Compare next to Download to see what went up and what went down against the same dates last year.

  1. Open Analytics and pick a Period.

  2. Click Compare, next to Download. The Compare to another period switch turns on.

  3. The default is the same dates last year. A Period longer than a year compares with the same number of days right before it.

  4. Want a different period? Pick a start date in From. The end date is set for you, so both periods have the same length.

  5. A line under the buttons says what is compared with what, for example: "Period Jan 1 – Oct 15, 2026 vs Compare Jan 1 – Oct 15, 2025".

  6. Each figure shows a percentage change: up, down, or No change. On the charts, full color is the Period and pale is Compare.

💡 New appears when the compare period had no donations at all. No data for Compare appears when the compare period has no data.

💡 To turn Compare off, click Clear in the Compare panel.

What's new in the report and export?

  1. A new ILS amount column — every donation also shows its value in shekels, so donations in different currencies can be summed.

  2. Payout-correction rows no longer appear in the general export — exactly as on the screen table. They still appear in the payouts report itself.

How do I download the data to a file?

  1. Filter the dashboard exactly as you want to see it — period, campaign, payment method and the rest.

  2. Click the Download button above the data cards.

  3. The file is built in the background; when it's ready it appears in the downloads screen.

  4. The file contains exactly the rows you filtered — the same numbers you see on screen, no surprises.

  5. It includes the full donation details: donor, campaign, amounts, payment method, receipt, dedication and more.

💡 Don't see the Download button? Downloads are enabled for your charity by Jgive — contact support.

Did this answer your question?