Ledgerly
Loading...

Bulk Upload Help

Complete guide for uploading transactions via CSV

Download Sample
CSV File Format

Your CSV file should have the following columns in the exact order shown below:

FieldRequiredDescriptionExample
dateRequiredTransaction date in YYYY-MM-DD format2024-01-15
typeRequiredTransaction typeincome, expense, or transfer
categoryRequiredTransaction categoryFood & Dining, Salary, etc.
amountRequiredTransaction amount (positive number)25.50
descriptionOptionalOptional description of the transactionLunch at restaurant
accountRequiredSource account name (must exist in your accounts)Checking Account
toAccountOptionalDestination account for transfersSavings Account
tagsOptionalComma-separated tagsfood,lunch,work
Important Notes
  • • Account names must match exactly with your existing accounts
  • • For transfers, both account and toAccount are required
  • • Tags should be comma-separated without spaces
  • • Amounts should be positive numbers (no currency symbols)