CityLights Help Back to the app
Help centre

Withdrawals and deposits report

Money taken out of and paid into the bank, per person and one by one, for any months and in one currency.

What this page is for

See how much each person took out of the bank and paid in over a period, and list every withdrawal and deposit behind those totals.

Who can use it

See bank withdrawals and deposits (by default Admin, Finance and Viewer).

How to run it

  1. Choose the months, the currency and, if you want, some people.
  2. Select Show.
  3. Export with CSV, Excel or PDF.

Fields and columns

Column Meaning
Withdrawn Money taken out of the bank.
Deposited Money paid into the bank.
Net cash taken out Withdrawn minus deposited: what the person took out and still holds or spent.
Original amount The amount in its own currency, when it differs from the report currency.

Statuses and automation

Each amount is converted at its own month's exchange rate. Amounts without a rate are left out and a warning shows.

Settings that change this page

The system currency (base currency under Settings).

FAQs

Which currency are the amounts in? Always the system currency (the base currency under Settings). Amounts recorded in another currency are converted at the exchange rate of their month. An amount whose month has no rate is left out and a warning with a link to Exchange rates appears; currencies are never added together or shown as separate totals.

Who is in the Unassigned row? Every amount with no person recorded, the Unassigned holder used for unpaid bookings, and people who are not members of your organisation (for example someone only known from imported data). They are added up in one row, so the per-person figures always add up to the total. People who left keep their own name.

Does this include transfers between staff? No. See Transfers or Cash in hand.

Troubleshooting

Problem What to do
A warning about exchange rates Add the missing monthly rates under Exchange rates.

Related pages