What if I don't have historical transactions to import - just yearly totals

When importing Contacts and their associated Transactions into Kindful, the best thing to do is to import each individual transaction for each contact record. 

But what do you do if you don't have individual transaction records? Perhaps all you have is a list of Contacts with yearly totals. Below explains how you can import yearly totals, and what it means as you use Kindful in the future.

Please NOTE: This is a non-standard way of using Kindful. Please be sure you note to yourself and other future users of your Kindful account.

OPTION: IMPORT YOUR CONTACT TOTALS AS TRANSACTIONS

Each historical total is imported as an individual transaction. This option is kind of like "fitting a round peg in a square hole". This a Non-Standard way of using Kindful.

Recommendations:
You will need to agree upon a few default transaction values for your Yearly Totals, and communicate this to all users of your system.

  • Pick a Campaign or Campaigns and Clearly Name them as such. You might consider including HISTORICAL in the Campaign name for clarity in future viewing of these transactions.
  • Pick a Transaction Type
  • Choose a Date convention. For example, if you have yearly totals, the first day of the fiscal year. 
  • Consider adding a transaction Note containing something like: "This is a historical total as of mm/dd/yyyy, and is not an individual transaction."

For Example:

  • Campaign = "Historical Totals"
  • Transaction Type = "Cash"
  • Date = 1/1/2012, 1/1/2013, 1/1/2014, 1/1/2015, etc
  • Note =  "This is a historical total as of mm/dd/yyyy, and is not an individual transaction."

Pros

  • This allows for viewing and reporting on the lifetime total for each contact as time goes on.
  • You will be able to view and report upon historical giving totals for the entire organization.

Cons

  • This means you'll have transaction records in Kindful that aren't actually transactions.
  • You'll have to remember and communicate with users of Kindful which transactions are really historical totals.
  • Those records will have something about them which is "wrong" - ie there will be a transaction type, date, etc which is dummy data. For example, all historical giving may be as "Cash" transactions with the date of the import.
  • This may confuse/complicate auditing in the future.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments