Connection Card Pro Help & Documentation

Importing Financials

You will be taken through a step-by-step guide to import your financials.  If you were previously using another platform, you will need to first export your information to a csv file format.

From the menu: Accounting > Financial Settings > Import Financials

• Data MUST be in CSV format
• Select what type of Data yours is, Single Rows or Split Transactions. Your data must be one of these types. If an export from a platform other than Aplos or Quickbooks, choose whichever one matches your data best.
• Single rows representing complete transactions (likely what they would get from an online banking if downloading as CSV)
• Split transactions (only the first record of each transaction should have date on it.) Aplos export and QuickBooks Split Transactions report will do this.
• We recommend going through your Export CSV file first to clean it up, get rid of any duplicate names, make sure everything is showing correctly in the right columns, and make sure all donor names match exactly what their current record in Connection Card pro shows, otherwise will create a new record if not an exact match. (If some new duplicate records are created after the import is complete, you can consolidate those to your original records which will then carry over any giving that is in that new record).
• For Fund and Register columns, choose a fund such as the General Fund.  Do not leave it based on your CSV as this may not show a fund or register name.
• Always choose “Unassigned” if doesn’t apply to any options and is not a column/info needed. Do not leave blank.
• Mark all as tax deductible if these are donations/tax deductible amounts.
• If it shows a Posting column from a QuickBooks csv file column, mark as “unassigned”.
• Check box to Create fund or account if it doesn’t already exist..
• Check box to create a person or company if it doesn’t already exist.
• You can refer back to your spreadsheet to verify columns, such as a credit or debit column. 
  
• For a Balance field, which will show as a column of numbers towards the end, choose UNASSIGNED. You do not want to import the balances from your exports.
• For matching transactions to Accounts on the next step, select an expense or income account.
  
• “Complete Import”