Is 04/05 April 5 or May 4? Send three fake customers through first, check every field, and write the format down before the real move.
Swipe or tap Next · checked on 2026-10-04
Not technical? Start here. Copy this prompt into ChatGPT or Claude (the free versions work) and it walks you through the whole guide, one step at a time, in plain English. It asks before it assumes anything and checks with you before anything that costs money, reaches a real customer or deletes something. The rest of the page is the same guide, written out, if you'd rather do it yourself.
The walkthrough prompt (copy all of it) · lines 1-4 of 111. Copy all copies the whole prompt; read it in full on the page.
Hi! Please be my patient guide for this step-by-step guide from Receipts Group: "Test your dates before you move your customer list"
The guide is here: https://receiptsgroup.com/guides/test-dates-before-moving-a-list (open it if you can; if you can't, everything you need is below).
About me: I run a small business and I'm not technical. Use plain words and short sentences.Hi! Please be my patient guide for this step-by-step guide from Receipts Group: "Test your dates before you move your customer list"
The guide is here: https://receiptsgroup.com/guides/test-dates-before-moving-a-list (open it if you can; if you can't, everything you need is below).
About me: I run a small business and I'm not technical. Use plain words and short sentences.
What this guide helps me do: Is 04/05 April 5 or May 4? Send three fake customers through first, check every field, and write the format down before the real move.
How to help me:
1. One step at a time. For each step, tell me in a sentence what it's for and exactly what to do (where to click, what to type, who to ask). Then stop and wait until I say "done" or tell you what I see.
2. Ask before you assume anything about my business, my tools, my team or my numbers. One question at a time.
3. If you use a technical word, explain it in plain English the first time.
4. Stop and check with me before anything that costs money, sends anything to real customers, or deletes anything.
5. Use only what I tell you or show you. Never make up numbers, names, results or quotes. If something's missing, ask me.
6. If I get stuck, or something looks different from what you expected, slow down and try another way.
The steps, from the guide:
Run the test:
Step 1. Add the three fake customers to the old system.
Type them in like any new customer. That tests the whole trip: what the old system sends out, not just what the new one takes in.
Step 2. Export the same way you'll export for real.
Use the same export button and settings you'll use for the real move. Then don't open and save the file in Excel or Sheets on the way. Opening it is how dates get re-read and zeros get dropped. Need to look inside? Open a copy, or open it in a plain text app like Notepad on Windows.
Step 3. Import it and check the mapping.
The new system will ask which column goes where. Slow down here. Look hard at any column called Number, ID or Date. "Number" might be a customer ID, not a phone number. If the import screen lets you pick a date format, pick the one your file really uses. Write down what you picked.
Step 4. Open each fake customer and check every field.
Open the records in the new system. Don't stop at the import summary. "Imported 3 of 3" means three rows went in. It doesn't mean they went in right. Check each field against the "It should show" column above:
- Dates: March 12, not December 3. March 25, not blank.
- Times: 9:00 AM and 2:30 PM, right where you typed them. If a time moved, check the time zone setting in both systems.
- Phone vs customer ID: each in its own box, and ID 00412 still has its zeros.
- Names: Zoë and O'Brien-Smith spelled exactly, with no odd symbols.
Step 5. Fix the first problem, then run it again.
Change one thing: the mapping, the date format on the import screen, or the date setting on the export. Delete the fakes from the new system and send them through again. Repeat until all three come out right.
Step 6. Write the format down, then clean up.
Fill in the format sheet below. Delete the three fake customers from both systems, or tag them TEST so no report counts them. Now do the real move, with the exact same settings.
When we get to it, use "The three fake customers (type them into your old system)" from the guide (fill in the blanks and brackets with my details):
---
TEST CUSTOMER 1: which way?
First name: TEST
Last name: Dateone
Phone: (XXX) 555-0101
Email: test1@example.com
Customer ID: DEMO-0001
Appointment: 03/12/2027 9:00 AM
Should show: March 12, 2027
TEST CUSTOMER 2: one meaning
First name: TEST
Last name: Datetwo
Phone: (XXX) 555-0102
Email: test2@example.com
Customer ID: DEMO-0002
Appointment: 03/25/2027 2:30 PM
Should show: March 25, 2027
TEST CUSTOMER 3: other boxes
First name: TEST Zoë
Last name: O'Brien-Smith
Phone: (XXX) 555-0103
Email: test3@example.com
Customer ID: 00412
Appointment: 2027-03-12 9:00 AM
Should show: March 12, 2027,
ID 00412, zeros kept
XXX = your own area code.
---
When we get to it, use "Format sheet" from the guide (fill in the blanks and brackets with my details):
---
FORMAT SHEET
From: _____________ (old system)
To: _____________ (new system)
Tested on: ________ By: ________
DATES
Old system exports: ___________
New system reads: ___________
Import setting we picked: ______
Safe format: YYYY-MM-DD
Time zone, old: ______ new: ______
PHONE
Column name in the file: _______
Goes into field: _______________
CUSTOMER ID
Column name in the file: _______
Goes into field: _______________
Zeros kept (00412)? [ ] yes
NAMES
Accents and apostrophes OK? [ ] yes
THE TEST
[ ] Customer 1: March 12, 9:00 AM
[ ] Customer 2: March 25, 2:30 PM
[ ] Customer 3: ID, phone, name OK
[ ] Fake customers deleted
---
Watch out for these (the guide's mistakes to avoid):
- Trusting the import summary "3 of 3 imported" counts rows. Open the records and look at each field.
- Testing with a date like 03/03 When the day and month match, it reads right either way and proves nothing. Use 03/12 to see which way it reads, and 03/25, which can only mean one thing.
- Opening the export in a spreadsheet and saving it That's where zeros vanish and dates get re-read. Look at a copy, or open it as plain text.
- Testing with real customers A real name in a test can get a call, a text or a reminder. Use TEST names, example.com emails and 555-0100 to 555-0199 numbers.
- Not writing it down Next year somebody runs the same import from memory. The format sheet is the memory.
When we're done, give me a short recap: what we did, what I decided, and the one thing to check again later.
Start by asking me a few quick questions about my business and what I already have, one at a time. Then begin with step 1.A date like 04/05 is just numbers. Some places write the month first, so it's April 5. Others write the day first, so it's May 4. Your software picks one based on its settings. It doesn't ask you.
ISO, the international standards group, uses this exact problem as its example: 01/05/22 could mean January 5, 2022, or May 1, 2022. Its fix is a format called ISO 8601: year, then month, then day. 2027-03-12 can only mean March 12, 2027.
Here's where it bites. The same file can be read two ways, depending on settings:
So a file can be fine, get opened once "just to look," and come out different. Nobody gets an error message. That's the scary part.
Three is enough. Each one tests something different. Put TEST in every name so nobody calls them, books them or counts them. Use contact details that can't reach a real person:
No customer IDs in your systems? Skip that line.
The three fake customers (type them into your old system) · Part 1 of 2 · Copy copies all 29 lines
TEST CUSTOMER 1: which way?
First name: TEST
Last name: Dateone
Phone: (XXX) 555-0101
Email: test1@example.com
Customer ID: DEMO-0001
Appointment: 03/12/2027 9:00 AM
Should show: March 12, 2027
TEST CUSTOMER 2: one meaning
First name: TEST
Last name: Datetwo
Phone: (XXX) 555-0102
Email: test2@example.com
Customer ID: DEMO-0002TEST CUSTOMER 1: which way?
First name: TEST
Last name: Dateone
Phone: (XXX) 555-0101
Email: test1@example.com
Customer ID: DEMO-0001
Appointment: 03/12/2027 9:00 AM
Should show: March 12, 2027
TEST CUSTOMER 2: one meaning
First name: TEST
Last name: Datetwo
Phone: (XXX) 555-0102
Email: test2@example.com
Customer ID: DEMO-0002
Appointment: 03/25/2027 2:30 PM
Should show: March 25, 2027
TEST CUSTOMER 3: other boxes
First name: TEST Zoë
Last name: O'Brien-Smith
Phone: (XXX) 555-0103
Email: test3@example.com
Customer ID: 00412
Appointment: 2027-03-12 9:00 AM
Should show: March 12, 2027,
ID 00412, zeros kept
XXX = your own area code.The three fake customers (type them into your old system) · Part 2 of 2 · Copy copies all 29 lines
Appointment: 03/25/2027 2:30 PM
Should show: March 25, 2027
TEST CUSTOMER 3: other boxes
First name: TEST Zoë
Last name: O'Brien-Smith
Phone: (XXX) 555-0103
Email: test3@example.com
Customer ID: 00412
Appointment: 2027-03-12 9:00 AM
Should show: March 12, 2027,
ID 00412, zeros kept
XXX = your own area code.Can't add customers to the old system? Add the three as new rows in a copy of the export file instead. Or let the prompt further down build them for your exact columns.
Type them in like any new customer. That tests the whole trip: what the old system sends out, not just what the new one takes in.
Use the same export button and settings you'll use for the real move. Then don't open and save the file in Excel or Sheets on the way. Opening it is how dates get re-read and zeros get dropped. Need to look inside? Open a copy, or open it in a plain text app like Notepad on Windows.
The new system will ask which column goes where. Slow down here. Look hard at any column called Number, ID or Date. "Number" might be a customer ID, not a phone number. If the import screen lets you pick a date format, pick the one your file really uses. Write down what you picked.
Open the records in the new system. Don't stop at the import summary. "Imported 3 of 3" means three rows went in. It doesn't mean they went in right. Check each field against the "It should show" column above:
Change one thing: the mapping, the date format on the import screen, or the date setting on the export. Delete the fakes from the new system and send them through again. Repeat until all three come out right.
Fill in the format sheet below. Delete the three fake customers from both systems, or tag them TEST so no report counts them. Now do the real move, with the exact same settings.
I've connected a lot of systems. The date box always looks the most innocent. So check it first.
One page. Fill it in after the test, keep it with your notes, and hand it to whoever runs the next import. No logins on it.
Format sheet · lines 1-11 of 29. Copy all copies the whole file; read it in full on the page.
FORMAT SHEET
From: _____________ (old system)
To: _____________ (new system)
Tested on: ________ By: ________
DATES
Old system exports: ___________
New system reads: ___________
Import setting we picked: ______
Safe format: YYYY-MM-DD
Time zone, old: ______ new: ______FORMAT SHEET
From: _____________ (old system)
To: _____________ (new system)
Tested on: ________ By: ________
DATES
Old system exports: ___________
New system reads: ___________
Import setting we picked: ______
Safe format: YYYY-MM-DD
Time zone, old: ______ new: ______
PHONE
Column name in the file: _______
Goes into field: _______________
CUSTOMER ID
Column name in the file: _______
Goes into field: _______________
Zeros kept (00412)? [ ] yes
NAMES
Accents and apostrophes OK? [ ] yes
THE TEST
[ ] Customer 1: March 12, 9:00 AM
[ ] Customer 2: March 25, 2:30 PM
[ ] Customer 3: ID, phone, name OK
[ ] Fake customers deletedWant a hand? Paste this into Claude or ChatGPT. It builds the fake customers for your exact columns, then checks the results with you. Only paste fake data. Never paste real customers into a chat.
The list-move test prompt · lines 1-4 of 16. Copy all copies the whole prompt; read it in full on the page.
I'm moving my customer list from [OLD SYSTEM] to [NEW SYSTEM]. Before the real move, help me run a test with three fake customers. I will only share fake data with you, never real customers.
Here are the column names from my export file (the first line only):
[PASTE THE FIRST LINE OF YOUR EXPORT FILE HERE]I'm moving my customer list from [OLD SYSTEM] to [NEW SYSTEM]. Before the real move, help me run a test with three fake customers. I will only share fake data with you, never real customers.
Here are the column names from my export file (the first line only):
[PASTE THE FIRST LINE OF YOUR EXPORT FILE HERE]
Please:
1. Make three fake test customers that fit these columns. Put TEST in every name. Use emails at example.com. For phones, use my area code and a number from 555-0100 to 555-0199.
- Customer 1: an appointment on 03/12/2027 at 9:00 AM.
- Customer 2: an appointment on 03/25/2027 at 2:30 PM.
- Customer 3: a customer ID that starts with zeros (00412), a name with an accent and an apostrophe (Zoë O'Brien-Smith), and the date written 2027-03-12.
2. Show them two ways: as CSV lines I can paste into a copy of my export file, and as a list I can type in by hand.
3. Go through my columns. Tell me, in plain words, which ones could get mixed up when they move. Look for dates, times, phone numbers vs customer IDs, names, and numbers that start with zero.
4. Then stop and wait. After I import them, I'll paste what the new system shows. Compare it field by field in a table: field, what I typed, what it shows, OK or problem. For each problem, give me the most likely cause in one sentence and the one setting to change.
5. When all three come out right, fill in a one-page format sheet: the date format, the time zone, which column goes into which field, and anything to watch next time.
Use short sentences and plain words. If you need something from me, ask one question at a time.The AI can only compare what you paste. Opening the records in the new system and looking is still your job.
Coastal Line Roofing is moving its customer list from an old scheduling app to a new customer system. The office manager adds the three fake customers to the old app, exports, and imports. Here's what the new system shows:
Two fixes. On the import screen, the date setting was day first. She switches it to month first. Then she maps the old app's "Number" column to Customer ID instead of Phone. She deletes the fakes, sends them through again, and all three come out right.
Her format sheet now says: dates go in month first, or as YYYY-MM-DD. "Number" goes into Customer ID. Both systems set to Eastern time. Nobody shows up on the wrong Tuesday.
"3 of 3 imported" counts rows. Open the records and look at each field.
When the day and month match, it reads right either way and proves nothing. Use 03/12 to see which way it reads, and 03/25, which can only mean one thing.
That's where zeros vanish and dates get re-read. Look at a copy, or open it as plain text.
A real name in a test can get a call, a text or a reminder. Use TEST names, example.com emails and 555-0100 to 555-0199 numbers.
Next year somebody runs the same import from memory. The format sheet is the memory.
What each page backs up is listed at the end of the full guide.
Not exciting? Correct. Neither is explaining why everyone showed up on the wrong Tuesday.
Want help setting this up? Receipts Group builds these systems.
Open the full guide as a page (every file in full, plus the table of contents).