💳

💳 Square Deposit Creator

Upload your Square transfer details CSV file to generate QuickBooks journal entries

Sending to: Rachel Alexandria (Alexandria Enterprises)
☁️

Drag and drop file here

Upload Square transfer details (.CSV)

No file selected.

📋 What This Tool Does

  • Groups transactions by deposit - Creates separate journal entries for each Square deposit
  • Calculates totals - Automatically sums sales, fees, and deposit amounts
  • Creates balanced entries - Ensures debits equal credits for each journal entry
  • QuickBooks ready - Generates properly formatted CSV for journal entry import

📁 Expected File Format

  • CSV files (.csv) exported from Square Dashboard
  • Must contain: Deposit Date, Collected, Fees, Deposited, Deposit ID columns
  • Transfer details format from Square's reporting section
  • Maximum file size: 16MB

📊 Journal Entry Structure

  • Square Sales (Credit) - Total collected amount
  • Square / PayPal Fees (Debit) - Processing fees
  • Verity Checking (1840) (Debit) - Amount deposited to bank
  • Square Savings Account (Debit/Credit) - Any holdback amount