How to Use QuickBooks Customer Phone Numbers for Faster Collections

QuickBooks Online stores up to three phone numbers per customer: Primary Phone, Mobile, and Alternate Phone. Most AR software reads the email address and stops there.

That's a missed opportunity. Phone numbers unlock text message reminders — and SMS gets responses that email simply doesn't.

Where QuickBooks Stores Customer Phone Numbers

When you open a customer record in QuickBooks Online, you'll find phone fields in the Contact info section:

• Primary Phone — typically a business landline or main number
• Mobile — the most valuable field for SMS reminders
• Alternate Phone — any additional number

For AR collection purposes, mobile is what you want. Primary Phone may be a front desk number that nobody checks, while the mobile goes directly to the decision-maker who can approve the payment.

If your customer records don't have mobile numbers filled in, it's worth spending 20 minutes adding them — the ROI in faster payment collection pays for itself quickly.

The Challenge: Keeping Phone Data in Sync

Many businesses add phone numbers to QuickBooks after setting up integrations. If your AR software only reads customer data once (at sync time) and never updates, those newly added phone numbers will never make it into your collection sequences.

The fix is continuous sync — every time your AR tool pulls invoice data from QuickBooks, it should also update customer phone and email fields from the latest QuickBooks data.

Dueflo syncs phone numbers on every QBO sync cycle, reading all three phone fields (Primary, Mobile, Alternate) in priority order. If a client has a Mobile number, that's what gets used for SMS reminders. No number? Email-only collection continues without interruption.

What If QuickBooks Doesn't Have the Phone Number?

Not every customer record will have a phone number — especially if you've been using QuickBooks for years before SMS collection was on your radar.

Rather than requiring you to go back into QuickBooks and update dozens of customer records, the better approach is to let your AR software handle it directly. Dueflo lets you add or edit a client's phone number right from the invoice dashboard — no QuickBooks detour needed. The phone number is stored against that debtor and used for all future SMS reminders.

The Right Sequence: Email First, SMS at Key Steps

The goal isn't to bombard clients with both email and text every time. That would feel spammy and damage relationships.

The right approach layers SMS into a primarily email-driven sequence at specific escalation points:

1. Day 1–7: Email reminders only. Give clients time to see and act on a professional email reminder.
2. Day 14 (Step 3): Add an SMS reminder. If 2 emails haven't gotten a response, a brief text to the right number often does.
3. Day 21–28: Email reminders continue escalating in tone.
4. Day 30 (Step 5): A final SMS reminder — short, clear, with a direct payment link.
5. Day 45: Final notice email if still no payment.

This sequence means your clients who respond to email never see an unexpected text. Your clients who don't open email get a second-chance touchpoint at the moments it matters most.

Measuring the Impact

Businesses using multi-channel AR collection (email + SMS) typically see:

• 15–25% higher collection rates compared to email-only
• Faster response times — many clients who receive an SMS pay within the same day
• Better relationship preservation — because you're not sending 10 emails, you're sending targeted, well-timed reminders on the right channel

The key metric to watch isn't open rate — it's days-to-payment. If your average invoice that goes 30+ days overdue is getting resolved in 35 days instead of 50, that's meaningful working capital improvement.

Getting Started

The simplest action you can take today:

1. Open QuickBooks Online and spot-check your top 10 customers — do they have mobile numbers?
2. Add missing mobile numbers to the Mobile field in each customer record
3. If you're using Dueflo, those numbers will sync automatically on the next cycle and SMS reminders will activate for any invoices on Professional or Business plan

Phone numbers in QuickBooks are free data you already have access to — or easy to add. Using them for AR collection is one of the highest-ROI changes you can make to your collections process.

---

Dueflo syncs QuickBooks phone numbers automatically and sends TCPA-compliant SMS reminders on Professional and Business plans. Start your 14-day free trial →