Create multiple files per journal type 1. Create multiple files per journal type Separate the lines by type: ACH for purchases, VEN for sales, OD for miscellaneous transactions, RS for payments/salaries, etc. Each file will only contain entries from the same journal—more secure for import. 2. Use specific columns in your Excel file Add a "Journal" column with the corresponding codes, for example: Account Label Debit Credit Journal Date Voucher 60701900 Purchase of goods 1000.00 ACH 07/24/2025 FAC- 123470600000 Sale of finished goods 5000.00 VEN 07/24/2025 FAC-4567 Advantage: Sage can import based on the specified journal, if you set up the correspondence plan correctly. 3. Filtered Batch Import from Excel Creates Excel tabs: "Purchases", "Sales", "Salaries", "Miscellaneous". Imports each tab separately by selecting the correct journal. You can add automation. You can use Visual Basic (VBA) in Excel to: Scan the entry type by row. Automatically generate the correct import files (per journal).