Automatic ACH payments in sales reports and loan offers

[pettylands]

I’ve noticed ACH payments received are not included in Square’s sales reports… I receive many ACH transfers that I do not invoice for as it’s done automatically in the clients’ systems and would like this data included in my reports

[Summer2024 · Accepted solution]

Hi, @pettylands ! Let me provide some clarification and workarounds below. 

Current Square ACH Reporting:

• Only ACH payments processed through Square (via invoices or Virtual Terminal) appear in sales reports
• External ACH deposits bypass Square's payment processing system, so they aren't automatically tracked

Possible Workarounds:

1. Manual Recording Option:

   • You can create manual entries for external ACH payments using Square's "Record External Payment" feature
   • Here's how:
     1. Go to Square Dashboard
     2. Select "Record Payment" or "Record External Payment"
     3. Choose "Bank Transfer/ACH" as payment type
     4. Enter the payment details
     • This will include these payments in your sales reports

2. Custom Item Solution:

   • Create a specific item for ACH payments
   • Record each ACH as a sale using this item
   • This helps track ACH payments within your Square reporting system

3. Alternative Tracking Methods:

   • Use Square's custom reports feature to create modified sales reports
   • Export Square data to spreadsheets and add ACH data manually
   • Consider using Square's API if you need automated solutions

Long-term Solutions to Consider:

1. If feasible, transition clients to Square's ACH payment tools:

   • Square Invoices with ACH payment option
   • Virtual Terminal for ACH payments
   • This would automatically include all ACH payments in your reports

2. For Reporting Accuracy:

   • Set a consistent schedule (daily/weekly) to record external ACH payments
   • Use reference numbers or notes to match bank deposits
   • Consider tagging or categorizing these payments distinctly

I hope this helps.