Excel for Accounting

8 articles

Learn how to maintain business accounts in Excel by creating a chart of accounts, recording transactions, and preparing income reports.

Learn how to calculate sales tax in Excel, find reverse sales tax, and automate calculations using VBA with practical tips.

Learn how to do GST reconciliation in Excel by calculating sales and purchase GST, creating summary sheets, and preparing adjustments.

Learn how to do bank reconciliation in Excel by classifying discrepancies, spotting mismatches, and reconciling your statement accurately.

Learn how to make a ledger in Excel with easy steps: set up the format, enter transactions, and calculate balances accurately.

Learn how to remove GST from total amount in Excel using formulas for fixed GST rates and extract variable GST values accurately from data.

Learn how to calculate GST in Excel by adding GST to base prices or extracting GST from inclusive prices using simple formulas.

Learn how to make a payroll in Excel by creating a payroll sheet and generating automated individual payrolls for accurate salary management.