One can record debit & credit of sales, purchase using a Journal through SUVIT. We have provided some steps and processes to follow while you create your excel sheet for journal data.
Put data in the first sheet
→ Only use Sheet 1 in your Excel file.
Headers go on the top row
→ Keep your titles like Date, Journal No., Amount, etc., in the first row.
No dots or dollar signs in column names
→ Don’t use symbols like "." or "$"
→ Don’t write anything above your column titles
Fill Journal Number for every entry
→ No empty journal numbers allowed.
Keep same invoice/reference numbers together
→ Use Excel sort to group them.
No NA or Not Applicable
→ If something is not available, leave the cell blank.
→ Don’t write NA, Not applicable, etc.
Date format should be DD/MM/YYYY
→ Example: 27/05/2022
Delete Grand Total or summary rows
→ Suvit only needs raw entries — no totals at the bottom.
Keep it short and sweet — max 5,000 rows
→ Don’t exceed 5,000 entries in one sheet.
Debit = Credit
→ Your total Debit amount and Credit amount must be the same.
Use proper formatting in Excel
→ Text = TEXT or General format
→ Numbers = Number format
→ Need help changing format? Click here
Add extra amounts horizontally (if needed)
→ For the same Invoice or Reference No., you can add more columns to the right (not downwards).
Save file in Excel Workbook format
→ Save as .xlsx — not CSV or PDF.
Want to learn how to upload the journal sheet? 👉 Learn More
