Using Google Sheets Last in, First out methodology The LIFO methodology assumes that items bought last will be sold first. LIFO holds true when inventory are kept in stacks; thus, the first one sold should be the last one acquired. Using this method, causes that last prices become your cost of goods sold, and older…
Category: Accounting
How to create an average cost inventory spreadsheet
Using Google Sheets Average Cost Calculation The average-cost method allocates the cost of goods available for sale on thebasis of the weighted-average unit cost incurred for a given period. Several businesses use this methodology when inventory units are similar in nature. Note, the calculated average does not refer to a per unit cost only; instead,…
How to create a FIFO Inventory Spreadsheet
Using Google Sheets Most of us work in businesses that already have their accounting software, that calculates for us all the account balances. We do not need to prepare agings, schedules, or inventory lists since the system takes care of us. However, several times your software does not accomodate your ideal solution for calculating an…
How to Create a Sum of the Years Depreciation Schedule
Using Google Sheets function SYD( ) To setup a Sum of the Years Depreciation Schedule for your fixed assets, you need to list your assets (column A). Then, include the item’s cost (column B), include each asset’s useful life in years (column C). Last, determine any residual value (optional), if not include $0 (column D)….
How to Manage a Business’ Accounts Receivable?
This site contains affiliate links to products and services. We may receive a commission for purchases made through these links. Definition: Amounts owed to the business by individuals or businesses. Receivables arise from credit sales of goods or services. To the company, these represent current assets; several companies have large amounts of accounts receivable. Financial…
Reconciling your Personal or Business Bank Account
This site contains affiliate links to products and services. We may receive a commission for purchases made through these links. For many of us, opening a bank account is our first formal financial transaction. Before that, we all paid with cash, and most of the time it was for miscellaneous things and not too expensive….
How to Use the Accounting Equation
This site contains affiliate links to products and services. We may receive a commission for purchases made through these links. The accounting equation denotes the basic elements of what the business owns and what it owes. The resources that will yield probable future benefits are the assets, and those rights or claims are the liabilities…
What are adjusting entries in Accounting?
Adjusting entries are required transactions for proper financial statements preparation. There are two categories divided in four types.
Standard Costing: A Practical Framework for Cost Control, Variance Analysis, and Strategic Decision-Making
Originally posted: October 16, 2016 Updated on: August 12,2026 Author: Orlando Gonzalez, CPA, MBA Standard costing is one of the most useful tools in managerial accounting and financial planning because it allows organizations to establish a measurable expectation for what a product, service, or process should cost under normal operating conditions. Rather than simply reporting…
How to Convert Cash Basis to Accrual Basis Accounting: A Practical Guide
Converting from cash basis to accrual basis accounting is an important accounting process for businesses that need more accurate financial reporting, improved budgeting, stronger financial controls, or compliance with an applicable financial reporting framework. Cash-basis accounting focuses primarily on when money changes hands. Accrual-basis accounting focuses on when revenue is earned and when expenses are…


