NetCash Manual CSV Import Tool

Overview

The NetCash CSV Upload Tool allows users to manually upload bank transactions in cases where the bank feed connection is unavailable. By using this tool, users can download bank transaction data as a CSV file from their banking institution and upload it directly into NetCash, ensuring bank activities are recorded and up-to-date within the system.

Key Assumptions

  • The user has already downloaded a CSV file of bank transactions from their financial institution.
  • Bank Institution and Account Setup: The bank institution and any associated bank accounts should be configured in NetCash.

Step-by-Step Process

  1. Navigate to CSV Upload
    • Go to NetCash > Setup > Import Bank Activity.
  2. Select Bank Institution and Account
    • Choose the relevant Bank Institution from the dropdown.
    • Optionally, select the specific bank account if uploading for a particular account.
  3. Upload CSV File
    • Click to drag and drop your file or browse and upload your CSV file.
    • The tool will display the first few rows of the file for preview, allowing users to verify the columns they want to map.
  4. Set Header and Data Rows
    • Indicate if the file includes a header row, and if so, specify the header row number.
  5. Map Fields
    • NetCash attempts to auto-map fields in the CSV file to NetCash fields. You may adjust field mappings by double-clicking any field to modify it to the correct field.
    • NetCash will ignore any columns where the mapping field is blank during import. So users do not have to delete any columns from the files they download from the bank they can just not set a mapping field.
  6. Configure Transaction Details
    • Transaction ID: If the CSV includes a transaction ID, assign transaction ID to that field; otherwise, NetCash will assign the transaction ID. If your bank does not give you a transaction ID in your CSV transaction download, then you will need to ensure you are not importing duplicate transactions as there will be no way for NetCash to know if something is a duplicate because each imported transaction will receive a different transaction ID if assigned by NetCash.
    • Map fields such as Date, Payment Channel, Debit/Credit Indicator, and Status as required.
  7. Template Setup (Optional)
    • For repeat imports, create a template for your institution by selecting Import and Create New Template from the dropdown icon in the import button, after mapping the fields.
    • To update an existing template, choose Import and Update Template. Templates streamline future uploads by saving mapping configurations.
  8. Finalize Import
    • After configuring fields and mappings, click Import to upload the transactions into NetCash.
    • You can view the transactions on the Manual Match or Bank Activity pages to confirm the import.

Undoing a CSV Upload

If erroneous or duplicate data is imported, it can be removed using the following steps:

  1. Navigate to Bank Imports Report
    • Go to NetCash > Reports > All Reports > Bank Imports Report.
  2. Delete the Import
    • Locate the recent upload, click Permanently Delete Bank Activity, and confirm by typing CONFIRM when prompted.
    • This deletion is irreversible, so review the report before confirming.

Limitations/Things to Be Aware Of

  • Ensure accurate mapping for data fields to prevent mismatched or missing data upon import.
  • Deletion of imported transactions is permanent and cannot be undone.
  • If no templates are created, field mapping must be reconfigured for each new upload.
  • If a transaction from a previous CSV import has already been matched and a user tries to delete that import, then the other transactions of the import that are not matched will be deleted, but the matched transaction will need to be unmatched before it can be deleted.

 

Was this article helpful?