How to Organize Bank Statements in Excel
When you download transaction data from your bank’s website, it will probably be downloaded as a CSV file. The data in the CSV file is not properly formatted or organized, making it harder to ...
Our Blog
How to Maintain Accounts for a Small Business in Excel
If you have a small business and are looking for a way to record transactions in Excel, look no further. The accounting procedure is a lot less complex for a small business, and even if you don’t ...
How to Calculate MACRS Depreciation in Excel (3 Examples)
In the USA, the MACRS is the official method provided by the IRS for calculating depreciation of tangible properties. For novice taxpayers, it might be hard to understand the MACRS depreciation ...
How to Use Sum of Years’ Digits Depreciation Formula in Excel
The Sum of Years’ Digits depreciation method is used in corporations that favor having a larger depreciation in the earlier years of the asset’s life. Most assets lose value quickly at the beginning, ...
How to Use Sales Tax Formula in Excel (Including VBA)
To ensure that the customers get the right price for the products, it is important to calculate the sales tax. While the US doesn’t have a ruling for the maximum retail price, sales tax is applied ...
How to Do GST Reconciliation in Excel (with Simple Steps)
GST (Goods and Services Tax) reconciliation is done to know whether the tax collected/paid when purchasing/selling something matches the CRA records of the government. In Excel, we can use various ...
How to Create a Personal Budget in Excel (2 Different Examples)
Creating and following a personal budget is a smart decision for any finance-literate person. A budget can help you track your income and expenses, and plan for the future. Excel, being a spreadsheet ...
How to Make a Break-Even Chart in Excel (with Simple Steps)
To determine a product’s sales target, it is important to calculate the break-even point. A break-even chart is the visual representation of the break-even analysis. Using the fixed cost, variable ...
How to Track a Stock Portfolio in Excel (with Detailed Steps)
To monitor your stocks, you might want to track the stock portfolio. In Excel, it is easy to create a sheet that will help you track the sharemarket status and the condition of your stocks. In this ...
