Clients Who Only Send PDF Bank Statements: A Bookkeeper's Workflow
Get data at source where you can, one channel for the PDFs, and a balance check on every statement: a workflow for practices whose clients never send a CSV.
Practical guides on invoices, guest registration, e-invoicing mandates and AI data extraction.
Get data at source where you can, one channel for the PDFs, and a balance check on every statement: a workflow for practices whose clients never send a CSV.
Four ways to turn a bank statement PDF into a spreadsheet, where each one breaks, and the two Excel formulas that prove opening balance + transactions = closing balance.
Spanish companies must comply with Verifactu before 1 January 2027 regardless of turnover; the self-employed before 1 July. Large businesses in the SII are excluded. The calendar with the exact legal reference.
The band at the bottom of a passport follows ICAO 9303 and carries its own check digits. How they are calculated, which misreads they catch, and how to extract the fields without retyping.
Every guest in Italy must be reported to the police within 24 hours, Italians included. The schedina fields, the deadlines, the penalties, and why a photo of the document is not identification.
Switzerland only mandates e-invoices for federal contracts above CHF 5,000. The QR-bill automates payment, not bookkeeping. What still arrives as a PDF and how to handle it.
Every foreign guest in Portugal, EU citizens included, must be reported through SIBA within three working days. Who reports, which fields the boletim needs, fines, and how to take them from a passport.
Spain, Italy, Portugal, France, Germany and Croatia side by side: which guests must be registered, through which portal or form, and the deadline โ plus what is the same everywhere.
German guests no longer fill in a Meldeschein, but foreign guests still sign one on arrival. The exact fields ยง 30 BMG allows, the one-year retention, the โฌ1,000 fine and the digital alternative.
Every foreign guest in French tourist accommodation, EU citizens included, must fill in and sign a police form kept for six months. Who is concerned, the exact fields, and how to fill it without typing.
Every guest in paid accommodation in Croatia must be registered in eVisitor within 24 hours of arrival and checked out within 24 hours of departure. Who must do it and how to take the data from an ID.
Austria only requires e-invoices for the federal government (since 2014). B2B is voluntary and no mandate date exists. What ViDA changes, and what to do with the PDFs that keep arriving.
Wave 24 brought every business above SAR 375,000 into ZATCA's Integration Phase by 30 June 2026. Foreign supplier invoices, printed receipts, delivery notes and purchase orders still arrive as PDFs and photos.
UAE businesses with AED 50M+ revenue must appoint an ASP by 30 October 2026 and go live on 1 January 2027; everyone else follows in July 2027. Here's what will still arrive as PDFs and photos after go-live.
KSeF became mandatory in February 2026 for large companies and in April 2026 for everyone else, with a soft landing until 2027. Foreign suppliers, receipts, delivery notes and small issuers still arrive as PDFs or photos.
German businesses must receive e-invoices since 2025; issuing becomes mandatory in 2027 above โฌ800,000 turnover and for all in 2028. Small invoices, tickets, foreign suppliers and delivery notes stay outside it.
Every French VAT-registered business must now be able to receive e-invoices, and SMEs issue them from September 2027. Six kinds of documents still arrive as PDFs or phone photos โ here's how to size them.
Belgium, Poland, France, Germany, Saudi Arabia and the UAE side by side โ dates, status and the six kinds of documents every mandate leaves as PDFs and phone photos.
Structured Peppol invoices are mandatory between Belgian businesses since January 2026 and the tolerance period is over. Foreign suppliers, exempt services, receipts and delivery notes still arrive as PDFs or photos.
The mandates are real and the dates are close โ but six categories of documents will still land in your inbox as PDFs and phone photos. Here's how to count yours before you budget.
The document type you pick decides which other fields become mandatory. Here is the exact mapping for passport, TIE/NIE and EU ID cards โ plus the four fields no document will ever give you.
The 19% rate is the easy part. What sinks Modelo 115 filings is the base (community fees and IBI passed on count), the โฌ900 threshold (per landlord, per year) and an exemption certificate that expires after 12 months.
Fourteen is the age at which a guest signs the entry form โ not the age at which a guest starts to count. A practical test for minors, groups and last-minute additions, with the fine brackets that apply when you get the headcount wrong.
Spain lets you hand over the keys with nobody on site. Italy, since the Council of State ruling of 21 November 2025, does not. Here is the distinction between identifying and registering a guest, the deadlines and fines in Spain, Italy and Portugal, and a remote check-in flow that survives an inspection.
Four different obligations get mixed up under the phrase "registering guests" in Spain: the police filing, the regional tourism licence, the NRUA rental number and the tourist tax. Here's the one-question test that tells them apart, what each one costs if you get it wrong, and how to feed all of them from a single ID scan.
Commercial lease abstraction costs $150โ400 per document. A residential rental agreement doesn't need 200 fields โ it needs about 18, and most of them are on deadline clocks that start the day it's signed. Here's the field list and the WhatsApp workflow that fills them.
Everyone quotes "fines from โฌ100 to โฌ30,000". The number that decides your exposure is the cliff at โฌ601 โ and in Italy and Portugal the penalty multiplies per guest, not per inspection.
Verifactu becomes mandatory on 1 January 2027 for corporate taxpayers and 1 July 2027 for everyone else. But it only regulates the invoices your clients issue โ the ones they receive, where all your staff hours go, are untouched. Here's how to plan both.
Spain's RD 238/2026 makes invoice recipients report acceptance, rejection and payment within four days. The wording excludes weekends and national holidays only โ a regional holiday does not stop the clock. Here's the counting, the volume math and the process that actually makes it feasible.
The deadline is not 2026: it's 1 October 2027 for companies over โฌ8M and 1 October 2028 for everyone else. Here's why the receiving side โ not the issuing side โ is what will actually break your process, and the order to prepare in.
Most VAT errors aren't arithmetic โ they're classification. Eight mistakes that turn deductible input VAT into a penalty, with the 2026 case law and the numbers behind each one.
In Mรกlaga province 32.80% of 2025 home purchases were made by foreigners. Most due-diligence guides audit the property; this one audits the buyer โ the exact document pack, when each piece must exist, and the cash rules that trigger a 25% penalty.
The one arithmetic check worth automating right after OCR: base + VAT โ withholding = total, to the cent, with a defined tolerance. Here is the exact rule, the tolerance to use, and the four failure modes it catches before a wrong number reaches your books.
A till receipt is not automatically a lost deduction โ and not automatically a valid one either. The thresholds, the two lines that decide it, the 16th-of-the-month deadline, and a procedure that survives an audit.
A Spanish DNI carries only about half the fields the traveller register demands โ and since June 2025 you are not allowed to keep a copy of it. Here is the field-by-field split of what you read off the document, what you have to ask for, and the check-in procedure that survives both a police and a data-protection inspection.
A 30-second triage to tell whether a scanned PDF is above or below the OCR line โ with the pixel maths, the WhatsApp compression trap, and the fields you must never accept without a human check.
A six-point pre-flight check per invoice, the arithmetic of what your current handover costs, and the rule that decides whether a document is deductible or just an expensive souvenir.
Anyone can list what a nota simple contains. What actually decides a deal is whether each charge is still alive: an embargo lapses in 4 years, a tax lien in 5, a mortgage in 20+1. Here is the reading order and the dates.
Clients already send you invoices by WhatsApp. Here's how to turn that mess into a structured intake channel โ with the numbers that say whether it pays off, and the retention trap that catches most practices.
September is not about "reviewing your numbers". It is about a specific arithmetic: the invoices you have not recorded inflate your October instalment payment, and one decision you cannot take until February.
97% of brokerage leaders say their agents use AI, yet only 17% of agents report a significant impact. The gap isn't prompting โ it's which tasks got automated. Here's the split, a three-question test and the arithmetic to run before any demo.
The 25% rule you learned is about to change from 'more than 25%' to '25% or more'. Here is the arithmetic, the step-by-step procedure and the four mistakes that turn a client file into a finding.
Q3 2026 gets filed between 1 and 20 October โ but the deadline that actually catches people out is 15 October. Here are the dates, the forms, the cost of being late, and a three-week plan to arrive with everything ready.
Nobody in the office can answer this question, and that's exactly the problem. Here's a repeatable way to measure the hours your agency spends re-typing documents โ and what those hours are actually worth.
A modern extraction template is not a map of coordinates โ it's a list of fields with names, types and plain-language descriptions. Here's how to build one in an afternoon, test it, and stop it from breaking when a supplier redesigns their invoice.
Peak occupancy, peak consumption and a billing calendar that arrives two months late. Here's why summer utility invoices pile up in vacation rentals, what 2026 changed in Spain, and a workflow that survives August.
"99% accurate" means nothing until you say per what. A practical guide to deciding which extracted fields deserve a human check, which don't, and how to avoid turning review into rubber-stamping.
Quotes, work orders and trade invoices rarely line up on their own. Here is a practical routine to match them building by building โ and the data you need to capture from each invoice to make it work.
Duplicate invoices quietly drain cash from small accounting teams. Here's how they get in, why manual review misses them, and the four checks that stop a double payment before it's booked.
Upload a photo of an ID card or passport and get the name, number, dates and MRZ data back as text instantly โ no account, no typing. Here's how it works and where it actually fits.
Since 2 April 2026, Spain's MiDNI app is as valid as the plastic card for in-person ID โ but you can't photocopy a QR. Here's how client identification really changes.
Upload a photo of a business card and get name, company, phone, email and website back as text instantly. No app, no typing, no account.
That invoice you just keyed in didn't cost you nothing. Between labor, errors and rework, hand-processing a single invoice runs $12โ$26. Here's where the money actually goes โ and how to get it back.
A deposit contract (contrato de arras) is only as safe as the paperwork behind it. Here is the exact checklist to gather before anyone signs โ and where deals actually go wrong.
If your agency intermediates property sales in Spain, you are an "obliged subject" under the AML law โ with real duties and fines up to โฌ10M. Here's the practical checklist.
You don't need a new ERP to stop typing invoices. You need the data to arrive in the system you already use. Here's how to get structured invoice data into Excel or your ERP through an API, and what to check before you wire it up.
Bundled OCR looks free because you're already paying for the software. The real price shows up the day you want to leave โ and it's paid in data, not euros.
One supply point, one PDF, several units. A defensible method for choosing the allocation key, splitting the bill by component instead of by total, reconciling to the cent and keeping an audit trail that survives a dispute.
August empties the office but documents keep arriving. Here's how a skeleton crew keeps the quarter's data flowing so September isn't a crush before the VAT deadline.
Photocopying every client's ID "just in case" is one of the fastest ways to earn a GDPR fine. Here's what data minimization actually requires โ and how to identify clients legally.
Template-based OCR promises accuracy but quietly turns into a maintenance job: one supplier moves a field and extraction breaks. Here's why per-supplier templates fail โ and how template-free AI reads any layout on day one.
Since December 2024, every guest you host in Spain must be reported to SES.Hospedajes within 24 hours. Here's exactly what to send, when, and how to stop losing an hour a day to manual data entry.
The VAT you never reclaim isn't stolen โ it's mislaid. Lost invoices, late bookings and mistyped totals quietly shrink your deduction every quarter. Here's where it leaks and how to plug it.
SES.Hospedajes has been mandatory since December 2024, with a 24-hour deadline per guest. Here's how to turn a photo of an ID sent over WhatsApp into the exact fields the register needs โ in seconds, no app.
The headline everyone gets wrong: VeriFactu is not mandatory in 2026. The dates moved to 2027. Here's what actually changed โ and the invoice problem it won't fix.
The Spanish Q2 2026 VAT return is due between 1 and 20 July. Here's a practical checklist to reconcile every invoice, apply the right rates, and avoid a correction later.
Learn how to save hours every week by sending your invoices to an AI-powered WhatsApp bot.