GST Sales Register & Invoice Management in Microsoft Excel | GST Reconciliation
I prepared a structured GST Sales Register in Microsoft Excel to maintain and organize sales invoice details for the financial year 2026–27.
Key tasks completed:
Recorded invoice numbers, invoice dates, and customer/party details.
Organized GSTIN, HSN codes, quantities, taxable values, and freight charges.
Maintained GST rate and IGST details for sales transactions.
Calculated invoice amounts and organized invoice-wise tax information.
Prepared a consolidated sales register with grand totals.
Identified missing invoice information and potential discrepancies for verification.
Skills demonstrated: Microsoft Excel, GST Accounting, Sales Register Preparation, Invoice Management, Data Entry, Bookkeeping, and Financial Reporting.
This project demonstrates my ability to maintain organized sales records, manage invoice data, and support accurate accounting and GST reporting for businesses.
I developed a professional Excel dashboard as a portfolio practice project to demonstrate my skills in financial data management, income and expense tracking, and business reporting.
Project Features:
Automated income and expense calculations.
Financial dashboard with key performance indicators (KPIs).
Transaction tracking and organization.
Expense analysis by category.
Financial charts and visual reporting.
Net income calculation.
Project Results (Sample Data):
Total Income: $46,200
Total Expenses: $9,090
Net Result: $37,110
Tools: Microsoft Excel
Skills: Data Analysis, Accounting, Financial Reporting, Data Entry.
This project demonstrates my ability to organize financial records, analyze business performance, and create clear financial reports using Microsoft Excel.
Note: This is a portfolio demonstration using fictional financial data.
Looking for someone to help manage your daily administrative tasks?
I’m Jericka, an Administrative Virtual Assistant offering support with data entry, email management, online research, spreadsheet updates, and document organization.
My goal is to help business owners stay organized, save time, and focus on what matters most.