Include Excel formulas for easy bookkeeping ✨

Include Excel formulas for easy bookkeeping ✨

Anyone doing accounting related business knows that there is a lot of information about accounting that we need to know and remember. But in fact, we only use part of it to record financial statements. Today, in our article, we will talk about the simple and concise accounting formula.

Depreciation cost is (asset value - salvage value) / year used.

Working with machines requires investment and deterioration. Therefore, as mentioned above, it counts as expenses in this part, including repair costs, various investment costs. There will be a fixed cost. same every year unless there is an investment in the purchase of additional machinery

Profit (net) is total income - total expenses.

used with the profit-loss statement It can be calculated by taking all parts of income (direct-indirect) together to deduct expenses and expenses. including tax will be net profit

Retained earnings at the end of the year are net profit + retained earnings at the beginning of the year - dividends paid.

Formula for managing retained earnings Let us see the growth from inception till date of calculation. whether there is an increase in profit accumulation or not, how much

Assets are liabilities + owner's equity.

basics of balance sheet used in planning the structure of the business because the assets of the business can happen because Creating debts of business owners to invest

The owner's start-up capital is retained earnings at the end of the year + paid-up capital.

The final part of the balance sheet report Let us see the overall change of the paid portion. and share value that the company has been listed on the stock exchange combined with retained earnings

Other recipes

Net purchase = shipping cost + purchase - discount received - return

Office materials used = Office materials remaining - Office materials before renovation

Cost of goods sold = Inventories (end of period) - Net purchases + Inventories (beginning of period)

Net Sale = Sell/Return Product - Discount Paid

Gross Profit = Cost of Goods Sold - Net Sales

Goods available for sale = net purchase + remaining inventory (beginning of the period)

Total Expenses = Net Profit - Total Revenue

-------------------------------------------------------------------------------------

Details of online marketing services

>> https://www.chatstickmarket.com/langran

Examples of various brands that we take care of online marketing