Documentation
Learn how to use Meridianos Pipeline P0
Data Formats
Understand supported file formats and data structure
CSV Format
Comma-separated values with required columns (date, account, debit, credit)
✓ Comma or semicolon separated
✓ Required columns: date, account, debit, credit
✓ Optional columns: description, reference
✓ UTF-8 encoding with BOM for Excel
Excel Format
XLSX files with accounting entries in standard accounting format
✓ XLSX format (Excel 2007+)
✓ Single sheet or multiple sheets
✓ Standard accounting column layout
✓ Maximum 10MB file size
Best Practices
Tips and tricks for accurate data entry and error-free analysis
Data Quality
- • Use consistent date formats (YYYY-MM-DD)
- • Validate amounts before upload
- • Include all required columns
- • Check for duplicates manually
File Preparation
- • Keep files under 10MB
- • Use UTF-8 encoding
- • Remove empty rows/columns
- • Save in supported format
Troubleshooting
Solutions to common issues and problems
File Too Large
Maximum file size is 10MB. Split your data into smaller chunks if needed.
Format Not Recognized
Ensure your file is CSV or XLSX with proper column headers (date, account, debit, credit).
Balance Check Failed
Check that total debits equal total credits. Review all entries for accuracy.