Skip to main content

Importing Financial Data: Bulk Receipts and Historical Balances via CSV in Edlio Accounting

How to format, upload, and validate CSV files to import bulk receipts, historical accounting balances, and event sales batches into Edlio Accounting.

Bulk Data Import in Edlio Accounting

Entering hundreds of individual receipts manually after high-volume school events (such as athletic ticket gate sales, book fairs, or orientation registrations) is time-consuming. Edlio Accounting provides a native Imports wizard inside Receipts to ingest bulk financial transactions from standardized CSV spreadsheets directly into your general ledger.

💡 Best-Practice Adoption Tip: Always download the official template directly from Receipts > Imports > Download Sample CSV before formatting your data. Verify that all Fund Account codes, Object codes, and transaction dates (YYYY-MM-DD) exactly match your active chart of accounts to prevent import validation errors.

Edlio Accounting Receipts Imports Tab

Step-by-Step Import Process

  1. Navigate to Receipts in the main navigation menu.

  2. Select the Imports tab.

  3. Click the Import Receipts button.

  4. Click Download CSV Template to review the required column headers:

    • TransactionDate (YYYY-MM-DD)

    • CustomerName or StudentID

    • FundAccountCode

    • ObjectCode

    • Amount

    • PaymentMethod (Cash, Check, Credit Card)

    • ReferenceNumber (Optional check number or transaction ID)

    • Description (Memo line)

  5. Upload your completed CSV spreadsheet.

  6. Review the Pre-Import Validation Summary. The system checks each row for valid fund codes and numeric formatting. Any row with an error is flagged with an explanation.

  7. Click Confirm & Post Import. Edlio Accounting generates all receipt records and places them in Undeposited Receipts ready to be grouped into a bank deposit.

Related Articles

Related Articles
Did this answer your question?