Elvanto allows you to import transactions and pledges. We’ll guide you below.
In This Article
-
Download sample import file (CSV)
-
Things to consider
-
Linking transactions and pledges to people
-
Importing Transactions
-
Importing Pledges
-
Performing your import
Download sample import file (CSV)
To view examples of how your information should be formatted, download the files below.
Things to consider
There are a couple of things to consider before importing your financial data.
Linking transactions and pledges to people
Financials need to be matched to an existing person in the database. Create a column in your import file that contains one of the following:
-
Giving Number
-
Full Name
-
Full Name (Last, First E.g: Smith, John)
-
First Name
-
Last Name
Importing Transactions
The transactions import tool can be used to import transactions and batches.
Person
-
Giving Number
-
Full Name
-
Full Name (Last, First E.g: Smith, John)
-
First Name
-
Last Name
Batch
-
Batch Name
-
Batch ID
Transaction
-
Transaction Date
-
Method (Cash, Check, Cheque, Credit Card, Bank Transfer, Direct Deposit, Automatic Direct Debit, Online, Other or any other custom value)
-
Cheque/Check Number (Only used if Cheque/Check is selected for Method )
-
Account (a valid Chart of Account that you created in your account)
-
Amount
-
Tax Deductible (Yes or No)
-
Memo (Notes for the individual transaction)
Add to Pledge
-
Pledge (Yes for transactions linked to pledges)
-
Pledge Start Date
-
Pledge Chart of Account
Importing Pledges
Pledges are estimates of monies given by people for a period of time.
Person
-
Giving Number
-
Full Name
-
Full Name (Last, FirstE.g: Smith, John)
-
First Name
-
Last Name
Pledge
-
Start Date
-
End Date
-
Account (a valid Chart of Account that you created in your account)
-
Frequency (blank for 1 time or enter Weekly, Monthly or Yearly)
-
Times (the amount of time the payment amount is to be taken)
-
Total Amount
Performing your import
To perform the import, log into your Elvanto account and navigate to the Admin Area. Click on Financial → Import. Once the page has loaded, select your import file to upload, and choose whether you are importing ‘Transactions’ or ‘Pledges’. From here, choose your date format and click ‘Continue’.
Your import file will then upload to our server. This may take some time depending on the size of your import file and internet speed. A page will then load and ask for you to match each column to a field in Elvanto.
Double check that your columns match correctly. Once you’re happy with the way it looks, you’re good to go! Click the ‘Import’ button to go ahead. Once again, this may take some time depending on how many records you are importing.
Once your import is complete, you will receive a notification and a record of how many records were added.
Need us to review your import file?
Our customer service team can review your import file prior to you performing the import. Feel free to contact us at any time at the chat bubble below.