How to Automate Expense Import into Sage 50

If you use Sage 50 España, you know CSV import has its quirks: semicolon delimiter, comma decimals, UTF-8 BOM encoding, specific field requirements... Maruxa generates the perfect CSV automatically.

The problem: manual data entry

Most Spanish businesses still enter receipts and invoices into Sage 50 manually. This means:

• Opening each receipt, reading merchant, tax ID, date, amounts
• Typing each field into the software
• Verifying VAT rates are correct (21%, 10%, 4%)
• Classifying each expense into the right accounting category
• Repeating 50-500 times per month

Result: 10+ hours per month on tasks AI can handle in minutes.

Sage 50 España CSV format

Sage 50 accepts CSV import, but the format is demanding:

• Delimiter: semicolon (;), not comma
• Decimals: comma (12,50), not period
• Encoding: UTF-8 with BOM (so accented characters display correctly)
• Fields: date, merchant, tax ID, tax base, VAT type, VAT amount, withholding, total, category, account code

One mistake in any of these details and Sage 50 rejects the import or data comes out wrong.

How Maruxa solves it

Maruxa automates the entire process end-to-end:

Step 1: Capture the receipt

Take a photo with your phone and send it via Telegram, or upload the image from the web dashboard.

Step 2: AI-powered OCR

AI automatically extracts: merchant, CIF/NIF, date, tax base, VAT type, VAT amount, withholding, and total. Works with crumpled, blurry, and faded thermal paper receipts. Accuracy: 95%+.

Step 3: Automatic classification

Maruxa classifies expenses using 50+ predefined rules for Spanish merchants (Mercadona → Groceries, Repsol → Fuel, etc.) and assigns the corresponding accounting code.

Step 4: Export to Sage 50

One click generates the CSV with the exact format Sage 50 needs: semicolon delimiter, comma decimals, UTF-8 BOM, all fields correct. Import directly without any manual adjustments.

Frequently asked questions

Does it work with A3, Holded, or ContaPlus?

Yes. The exported CSV is standard and compatible with any accounting software that imports CSV.

Does it detect duplicate receipts?

Yes. Maruxa uses hash-based duplicate detection to prevent importing the same expense twice.

Can I export 100+ receipts at once?

Yes. Batch export generates a single CSV with all expenses from your chosen period.