Payment files
- How to create a SEPA XML payment file from Excel
Turn an Excel or CSV list of payees into a SEPA credit transfer XML (pain.001) your bank accepts: the columns you need, the checks that matter, and how to upload it. - pain.001.001.03 vs pain.001.001.09
The practical differences between the 2009 and 2019 versions of the SEPA credit transfer XML: BICFI, execution date, structured addresses, UETR and LEI. - SEPA structured addresses: the November 2026 deadline was postponed
The EPC planned to stop unstructured addresses in SEPA payments on 15 November 2026. On 9 September 2026 it postponed that date. What changes for your pain.001 files. - How to create a NACHA ACH file from Excel
The structure of a NACHA file (records 1, 5, 6, 8, 9), the fields you need in your spreadsheet, the routing-number check, entry hash and blocking – explained simply. - How IBAN validation works
What an IBAN check really verifies, how the two check digits are calculated with mod 97, a worked example, and what validation cannot tell you. - How to create a SEPA direct debit file (pain.008) from Excel
How to turn a spreadsheet of members or customers into a SEPA Direct Debit collection file (pain.008): the columns, FRST vs RCUR, CORE vs B2B, and the checks banks run. - The ABA (Cemtex) bulk payment file, explained
The Australian ABA / Cemtex direct entry file, line by line: the 120-character header, detail and total records, BSB and account rules, transaction codes and balancing. - FRST vs RCUR: SEPA direct debit sequence types
A clear guide to SEPA Direct Debit sequence types FRST, RCUR, OOFF and FNAL: what the EPC rulebooks say since 2016, what banks still ask for, and how to avoid rejected pain.008 files. - NACHA file format explained, record by record
How a NACHA ACH file is laid out: 94-character records, file and batch headers, entry details, the entry hash, control totals and blocking to 10 lines, with a real example. - SEPA XML file rejected: what the error codes mean and how to fix them
Why banks reject pain.001 SEPA payment files: the pain.002 status reason codes AM10, AM18, DU01, FF01, CH04, AC01 and others explained, with the usual cause and the fix.
Bank statements, e-invoices, PDFs, spreadsheets, photos and ops checklists
- How to convert MT940 to Excel
What the tags in an MT940 file mean (:20:, :25:, :60F:, :61:, :86:, :62F:), how to read a :61: statement line, and how to turn the file into an Excel sheet with a balance check. - camt.052 vs camt.053 vs camt.054
The three ISO 20022 cash-management messages explained: intraday report, end-of-day statement and debit/credit notification – and how to open them in Excel. - Analysis ToolPak alternatives in Google Sheets
Built-in Google Sheets formulas that replace the Analysis ToolPak: T.TEST, F.TEST, CORREL, LINEST and CHISQ.TEST, plus how to do a one-way ANOVA with formulas. - Arabic PDF to text: which method keeps the letters right?
Copy-paste, Word, Google Docs OCR or a bidi-aware converter? Which way of getting Arabic text out of a PDF keeps the letters and word order correct, and when to use each. - Fix wrong dates after a Google Photos Takeout export
After a Google Takeout export, photos show the export date and no location. Why the date is in a separate JSON file, the file-name traps, and how to write it back into the photos. - Is MT940 going away? MT940 vs camt.053 explained
What the Swift ISO 20022 migration means for MT940 statements: the November 2025 and November 2028 dates, the SCORE exception for corporates, and how camt.053 differs. - Polish KSeF e-invoices explained in English
Got a Polish KSeF invoice as XML or a PDF with a QR code? What KSeF is, the 2026–2027 dates, and an English guide to FA(3) fields: P_1, P_2, P_15, P_13_1, FaWiersz, VAT codes. - Gmail follow-up tracker without a CRM
How to track Gmail follow-ups without a full CRM: last contacted, who owes a reply and cold deals in your own Google Sheet, with a free FollowSheet template. - A free Gmail CRM in Google Sheets
Build a free Gmail CRM in Google Sheets: the columns to use, a copy-paste status formula, a small Apps Script that fills in last contacted, and when a ready-made template is easier. - Recruiter follow-up tracker in Google Sheets
How recruiters can track candidate and client follow-ups with Gmail plus a Google Sheet: a free manual method first, then optional sync. Honest about no LinkedIn sync. - Gmail follow-up reminders without an extension
How to remind yourself to follow up in Gmail without a Chrome extension: snooze, templates, filters, and a Google Sheet chase list. FollowSheet is one optional path. - Employee offboarding checklist: access revocation, Day 0 to Day 30
A free employee offboarding checklist for access revocation: what to do before the last day, the Day 0 order (identity, Slack, AWS, GitHub, password manager), Day 1, Day 7 and Day 30. - How to track unpaid invoices in Google Sheets, with Gmail reminders
A free way to track unpaid invoices in Google Sheets: the columns, an overdue formula, a 3-step reminder schedule, and how to see in Gmail which clients replied. No invoicing app needed. - A late-invoice chase schedule you can run from a spreadsheet
A repeatable late-invoice chase schedule you can run from a spreadsheet: pre-due, due-day, +7 and +14 reminders, what to log, and when UK statutory interest may apply for B2B debts. Not legal advice. - WISP annual review checklist for tax preparers
A plain-English WISP annual review for tax offices: MFA, access reviews, training, vendors, encryption, incidents and sign-off, mapped to 16 CFR 314 and IRS Pub 5708 / 4557. Not legal or tax advice. - How to track retention release dates on GCC construction projects
A practical way for GCC contractors and subcontractors to track retention held, both release dates, applied vs certified and variations, with a free calculator. Common practice per Chambers 2026; your contract decides. Not legal advice. - Salon rebooking on WhatsApp and commission before VAT: a simple routine for UAE salons
A simple routine for UAE salons and barbershops: find clients due to rebook, send an English or Arabic WhatsApp message, track no-shows and work out commission before 5% VAT. Free calculator. Not legal or tax advice. - How to write a car repair quote with 5% VAT and send it on WhatsApp (UAE)
What to put on a car repair quotation or job card in the UAE: plate, odometer, complaint, parts and labour lines, 5% VAT and validity, in English and Arabic, sent as a PDF on WhatsApp. Quotes are not tax invoices. Not tax advice. - Sterilisation log and recall follow-up for small dental clinics in the UAE
What a small UAE dental clinic can record in its sterilisation logbook (with DHA CG-10 and ST-45 references), a daily checklist, and a simple recall and treatment-plan follow-up routine. Operational records only; not clinical or legal advice. - How to track payment applications: applied vs certified vs paid (GCC subcontractors)
How GCC subcontractors can track each interim payment application: applied, certified, paid, the gap between them, retention and ageing, in one sheet. Common practice only; your contract decides. Not legal advice.