Monthly web income reconciliation

Login to the 24-7 web admin system (contact worthers if you need an id)
If you have the correct access, you should see a 'Reports (extract data)' link (again, if you don't see this, contact worthers to arrange access). Click on the link.
Select the 'Order Summary - Development' report.
Enter the dates you are interested in. Click the 'Create Report' button.
Save the resulting file to your computer.

Once the file has downloaded, you can view it in excel.

Exclude 'postcallback' items - these are most likely failed payments.
Add the amounts under each category in the accounts, which can be identified using the 'product_name' and 'type_name' columns. At the time of writing these are conferences, roundtable, one-off donations (donations and donations agaist orders), prayer room donations and regular donations (futurepay).
Check the amounts with the General Manager to see if there are any donations that have been made erroneously (e.g. conference payments as donations), or one-off donations that need to be classified as something particular (e.g. base tithes).

Futurepay Specifics

Donations that have anything in the 'valid_transaction' column need to be removed from the figures, these are failed futurepay agreements.
If you are looking at multiple months, you need to add the amount for each month - the report will only include the amount for the first row of a group of futurepay rows.
Currently the report doesn't show the first months payment. For now, this first months payment should be applied retrospectively in the following months reconciliation. (Not applicable for Birthday appeal - check with General Manager each month)