Write-off of administrative and commercial expenses to cost price
Write-off of administrative and commercial expenses occurs through the 90th account as follows:
- Dt 90 subaccount “Administrative expenses” Kt 26;
- Dt 90 subaccount “Business expenses” Kt 44.
Let's dwell on the choice of method for writing off expenses from the 26th account.
An organization can choose and record in its accounting policy one of 2 methods of writing off to the following accounts:
- 20 (23, 29);
- 90.
With method 1, general business expenses participate in the formation of the full cost of finished products, ending up in cost accounts in full at the end of the month. They can be distributed between main, auxiliary and service industries, as well as between types of products. In the future, from the 20th (23rd, 29th) account, these expenses will go to the finished product accounts and will be written off in proportion to the volume of products sold to the cost price.
With the 2nd method, the financial result includes the entire amount of general business expenses incurred during the month, without being distributed between the products sold and those remaining in the warehouse. The 2nd method makes it much easier to write off expenses from the 26th account, and also increases expenses, reducing profits. The organization must describe the choice of method for writing off general business expenses in its accounting policy.
The chart of accounts does not allow you to choose which account to write off sales expenses to - only to the 90th one. However, the organization can choose whether to write them off completely or partially. Partial write-off implies a monthly distribution between goods sold and those remaining in the warehouse:
- for manufacturing companies - packaging and delivery costs;
- for trading companies - delivery costs.
Other items of selling expenses are written off in full.
Read about the distribution of delivery costs in the article “How to correctly calculate transport costs (nuances)?”
Determination of sales revenue
The organization, as a result of its activities, receives revenue from the sale of goods, work performed, and services provided.
Sales revenue is the main financial foundation that allows a company to live and develop.
Revenue is usually calculated using the following formula:
Revenue | = | The price of the product | * | Quantity of goods |
As can be seen from the formula, the amount of revenue is affected by:
- the price of the product;
- the quantity of goods that the organization sells.
Example 1. ABC LLC produced a batch of chairs at a price of 1,500 rubles. The batch size was 1000 pieces.
- Revenue should be 1500*1000=1,500,000 rubles.
- As a result of low demand for chairs, the organization is forced to reduce the price to 1,250 rubles.
- Revenue in this case will be 1250*1000 = 1,250,000 rubles.
- In the event of the loss of part of the batch (a fire in the warehouse, resulting in the loss of 380 chairs), in order to maintain the amount of revenue (1,250,000 rubles), ABV LLC has to raise the price: 1,250,000/(1,000-380) = 2,016 rubles for 1 chair.
Determination of financial results for core activities
Postings to subaccounts of the 90th account are made throughout the year, accumulating the amounts of income and expenses. This approach makes it easy to generate the appropriate lines in the income statement. To obtain information about the organization's performance for the month, the accountant calculates expenses (turnover on the debit of the 90th account) and income (turnover on the credit of the 90th account). The difference between these values is profit or loss for the month; this value is reflected by posting Dt 90.9 Kt 99 when making a profit or Dt 99 Kt 90.9 when receiving a loss.
As a result, by the end of the year, a final balance will be formed on all subaccounts used by the organization, which must be reset to zero. For subaccounts with a debit balance, an entry for its full amount is made on the credit of this subaccount and the debit of subaccount 90.9, for subaccounts with a credit balance - vice versa:
Dt 90.1 Kt 90.9
Dt 90.9 Kt 90.2
Dt 90.9 Kt 90.3, etc.
Sales analysis is one of the main aspects that must be taken into account when developing an organization's marketing policy. Therefore, it is important to set up the correct analytics for account 90. Most often, sales analysis is carried out by type of product, by geographic location, by counterparty, by structural division of the organization, etc. Analytical accounting is organized depending on the needs of users for accounting information.
Results
Account 90 is necessary to collect data on income and expenses for activities that the company considers normal for itself. Income is recorded on the credit side of the account, and expenses are recorded on the debit side. The company can independently enter subaccounts to the 90th account - depending on business conditions and the accounting data used.
Accountants, especially beginners, cannot always understand which income is normal for a company and which is other. As a result, it is not completely clear which account (90 or 91) the revenue should be reflected in in each specific case. Let's look at it in order.
Income received by the organization, according to the norms of accounting legislation, is divided into income from ordinary activities and other income. Organizations are given the right to independently qualify income, taking into account their nature, conditions of receipt, as well as the direction of the organization’s activities.
Commercial organizations that are legal entities must generate information about income, guided by the Accounting Regulations “Income of the Organization” PBU 9/99, approved by Order of the Ministry of Finance of Russia dated May 6, 1999 No. 32n (hereinafter referred to as PBU 9/99).
The income of an organization in accordance with paragraph 2 of PBU 9/99 is recognized as an increase in economic benefits as a result of the receipt of assets (cash, other property) and (or) repayment of liabilities, leading to an increase in the capital of this organization. Meanwhile, not all funds and property received by an organization can be recognized as income of the organization. Contributions from participants (owners of property) are not recognized as income of the organization. In accordance with paragraph 3 of PBU 9/99, receipts from other legal entities and individuals are not recognized as income of the organization:
- amounts of VAT, excise taxes, export duties and other similar mandatory payments;
- under commission agreements, agency and other similar agreements in favor of the principal, principal and the like;
- in advance payment for products, goods, works, services;
- advances in payment for products, goods, works, services;
- deposit;
- as collateral, if the agreement provides for the transfer of the pledged property to the pledgee;
- in repayment of a loan granted to the borrower.
Paragraph 4 of PBU 9/99 provides a classification of income, according to which the income received by the organization is divided into income from ordinary activities and other income. The organization must provide for the chosen procedure for recognizing income in the order on accounting policies for accounting purposes. Other income also includes extraordinary income, that is, income received as a result of emergency situations. The criteria for classifying receipts as income from ordinary activities are determined by the organization independently and are fixed in the company’s accounting policies. As a rule, income from ordinary activities is recognized as income received by an organization from its main type of business. If there are several types of activities, the threshold of materiality of “ordinary” income in the total volume of income received by the organization is traditionally used as a criterion for recognizing income from ordinary activities.
The materiality criterion used by the organization to classify income is also fixed in the accounting policy (usually 5%).
In essence, income from ordinary activities of an organization is revenue from the sale of products, goods, performance of work, and provision of services.
Accordingly, all other receipts other than revenue, including those arising as a consequence of extraordinary circumstances of the organization’s economic activities, are considered other income.
What is this?
Revenue represents the income that an organization or enterprise receives over a certain period of time through the sale of a number of goods or services. This is the final stage of the company’s commercial or non-commercial activity, and the calculation is made by multiplying the price of the product by the number of units sold.
Net sales revenue is recognized as profit minus indirect taxes . It is an indicator of the organization's performance.
Revenue from the sale of sales objects is divided into two types:
- Gross revenue is the total amount including taxation (excise taxes, customs duties, VAT).
- Net revenue is profit from sales of products, works or services without taxation.
You will learn about how such sales revenue is calculated in a special material.
The tax calculation looks like this: let’s denote the amount by the letter C, then VAT=C*18/100. According to this calculation, with revenue of 100,000 rubles, VAT will be 18,000.
Including tax
To make such a calculation, the amount including VAT is designated Sn. The calculation turns out like this:
Сн = С + С*18/100 = С*(1+18/100) = С*1.18.
Then, with revenue of 100,000 rubles, the result will be 118,000.
In the Russian Federation, an invoice document is used to calculate value added tax . The law establishes clear rules for filling out this form and its format.
Without him
To calculate the value of profit without this indirect tax, the same formula is used as a basis. When designating N=18/100, it turns out that Сн = С+ N*С = С*(1+N).
Thus, C = Cn/(1+N) = Cn/(1+0.18) = Cn/1.18.
If difficulties arise when working with formulas, then specialized online calculators simplify the work of taxpayers . With their help, data is calculated quickly and accurately.
Conditions for recognizing revenue from ordinary activities in accounting
Paragraph 12 of PBU 9/99 defines five conditions, upon the simultaneous fulfillment of which revenue is recognized in accounting:
- the organization has the right to receive revenue, which arises from a specific agreement or is confirmed in another appropriate manner;
- the amount of revenue can be determined;
- there is confidence that as a result of a particular transaction there will be an increase in the economic benefits of the organization. Such certainty exists when the organization received an asset as payment or there is no uncertainty regarding the receipt of the asset;
- the right of ownership (possession, use and disposal) of the product (goods) has passed from the organization to the buyer or the work has been accepted by the customer (service provided);
- the expenses that have been or will be incurred in connection with this operation can be determined.
If at least one of the conditions listed above is not met in relation to the funds and other assets received by the organization, the organization’s accounting records recognize not revenue, but accounts payable.
Revenue from the provision for a fee for temporary use (temporary possession and use) of the organization's assets, rights arising from patents for inventions, industrial designs and other types of intellectual property and from participation in the authorized capital of other organizations is recognized if only three conditions are simultaneously met:
- the organization has the right to receive revenue arising from a specific contract or otherwise confirmed in an appropriate manner;
- the amount of revenue can be determined;
- there is confidence that a particular transaction will result in an increase in the economic benefits of the organization.
To summarize information on income and expenses associated with ordinary activities, as well as to determine the financial result for them by the Chart of Accounts for accounting financial and economic activities of organizations and the Instructions for its application, approved by Order of the Ministry of Finance of Russia dated October 31, 2000 No. 94n, Account 90 “Sales” is intended.
The amount of revenue from ordinary activities, namely from the sale of goods, products, performance of work, provision of services, when recognized in accounting, is reflected in the credit of account 90 “Sales” and the debit of account 62 “Settlements with buyers and customers.” To account for the receipt of assets recognized as revenue, subaccount 90–1 “Revenue” is provided, entries in which are made cumulatively during the reporting year.
Example. In 2021, the Organization received revenue from the sale of goods in the amount of RUB 1,770,000. (including VAT - 270,000 rubles). The cost of goods sold was 900,000 rubles, expenses for selling goods were 255,000 rubles.
The following entries must be made in accounting:
- Debit 62 Credit 90–1 - RUB 1,770,000. — revenue from the sale of goods is reflected;
- Debit 90–3 Credit 68, subaccount “VAT calculations” - 270,000 rubles. — VAT charged;
- Debit 90–2 Credit 41–900,000 rub. — the cost of goods sold is written off;
- Debit 90–2 Credit 44–255,000 rub. m sales expenses are written off;
- Debit 90–9 Credit 99–345,000 rub. (1,770,000–270,000–900,000–255,000)—profit from sales is reflected.
Exemption from payment if sales volumes are less than two million rubles
Firms and individual entrepreneurs whose sales volumes are not high, according to the Code of the Russian Federation, have the right not to pay value added tax. This benefit comes into force if, for three calendar months, the total income from the sale of trade items or the provision of services (not taking into account tax) is less than 2 million rubles (clause 1 of Article 145 of the Tax Code of the Russian Federation).
Important! If, if there is a tax exemption, during the next three months the total profit (excluding tax) exceeds this amount, then the preferential right is canceled. The tax is restored and payable in the accepted manner, starting from the month where the excess occurred (clause 5 of Article 145 of the Tax Code).
We talked about the rules for displaying income of individual entrepreneurs on the simplified tax system here.
Other income in accounting
The list of other income is given in paragraph 7 of PBU 9/99 and is open. Other income is:
- receipts related to the provision of the organization’s assets for temporary use for a fee;
- receipts related to the provision for a fee of rights arising from patents for inventions, industrial designs and other types of intellectual property;
- proceeds related to participation in the authorized capitals of other organizations (including interest and other income on securities);
- profit received as a result of joint activities;
- proceeds from the sale of fixed assets and other assets other than cash (except foreign currency), products, goods;
- interest received for providing the organization's funds for use, as well as interest for the bank's use of funds held in the organization's account with this bank;
- fines, penalties, penalties for violation of contract terms;
- assets received free of charge, including under a gift agreement;
- proceeds to compensate for losses caused to the organization;
- profit of previous years identified in the reporting year;
- amounts of accounts payable and depositors for which the statute of limitations has expired;
- exchange differences;
- the amount of revaluation of assets;
- Other income.
The chart of accounts for accounting the financial and economic activities of organizations and the Instructions for its application, approved by the Order of the Ministry of Finance of Russia dated October 31. 2000 No. 94n, account 91 “Other income and expenses” is intended to summarize information on other income and expenses of the reporting period.
It is recommended to open the following sub-accounts for account 91 “Other income and expenses”:
- 91–1 “Other income”;
- 91–2 “Other expenses”;
- 91–9 “Balance of other income and expenses.”
Receipts of assets recognized as other income are recorded in subaccount 91–1 “Other income”. Subaccount 91–9 is intended to identify the balance of other income and expenses for the reporting month.
Accounting for account 91 is carried out as follows. Cumulatively during the reporting year, entries are made in subaccounts 91–1 and 91–2. Each month the balance of other income and expenses is determined by comparing the turnover in the debit of subaccount 91–2 and the credit of subaccount 91–1, which is then written off from subaccount 91–9 to account 99 “Profits and losses”. That is, account 91 does not have a balance at the reporting date.
At the end of the reporting year, subaccounts opened to account 91 “Other income and expenses,” with the exception of subaccount 91–9, are closed with internal entries to subaccount 91–9. For account 91, analytical accounting should be kept for each type of other income and expenses in such a way that it is possible to identify the financial result for each operation.
The order in which other income is recognized in the accounting records of an organization is stated in paragraph 16 of PBU 9/99. If all five established conditions for revenue recognition are met, other revenues are recognized in accounting in the following order:
- proceeds from the sale of fixed assets and other assets other than cash (except foreign currency), products, goods, as well as interest received for providing the organization’s funds for use, and income from participation in the authorized capital of other organizations (when this is not the subject of activities of the organization). In this case, for accounting purposes, interest is accrued for each expired reporting period in accordance with the terms of the agreement;
- fines, penalties, penalties for violation of the terms of contracts, as well as compensation for losses caused to the organization - in the reporting period in which the court made a decision to collect them or they were recognized as a debtor;
- the amount of accounts payable and depository debt for which the limitation period has expired - in the reporting period in which the limitation period has expired;
- the amount of revaluation of assets - in the reporting period to which the date as of which the revaluation was made relates;
- other receipts - as they are formed (identified).
Let's look at some examples of income classified by PBU 9/99 as other income. Example. The organization has entered into a lease agreement under which it leases equipment it owns for a period of 1 month. Providing property for rent is not the main activity of the organization. Rental cost - 36,580 rubles, including VAT 18% - 5,580 rubles. The specified amount is transferred to the organization's bank account upon expiration of the lease term. The organization conducts settlements with the tenant on account 76 “Settlements with various debtors and creditors”.
— Debit 76 Credit 91–1 “Other income” — 36,580 rubles. — rent accrued;
- Debit 91–2 “Other expenses” Credit 68 “Calculations for taxes and fees”, subaccount “Calculations for VAT” - 5580 rubles. — the amount of VAT on rent has been accrued;
— Debit 51 “Current accounts” Credit 76–36,580 rub. — the rent amount has been credited to the bank account.
Example. A VAT payer organization sells a car in November. The contractual cost of the car is 172,280 rubles, including VAT 18% - 26,280 rubles. The initial cost of the car is 336,960 rubles.
The useful life established by the organization when accepting the vehicle for registration is 5 years, the actual service life until the moment of sale is 3 years.
Depreciation was calculated using the linear method, the amount of accrued depreciation was RUB 202,176. The residual value of the car is RUB 134,784.
- Debit 76 “Settlements with various debtors and creditors” Credit 91–1 “Other income” - 172,280 rubles. — the buyer’s debt for the sold car is taken into account;
— Debit 91–2 “Other expenses” Credit 68 “Calculations for taxes and fees” — RUB 26,280. — VAT is charged on the sales amount;
— Debit 01–2 “Disposal of fixed assets” Credit 01–1 “Fixed assets in the organization” — RUB 336,960. — the disposal of the car as a result of sale is reflected;
— Debit 02 “Depreciation of fixed assets” Credit 01–2 “Disposal of fixed assets” — 202,176 rubles. — the amount of depreciation accrued during the operation of the vehicle is written off;
— Debit 91–2 “Other expenses” Credit 01–2 “Disposal of fixed assets” — 134,784 rubles. — the residual value of the sold car is written off;
- Debit 51 “Settlements” Credit 76 “Settlements with various debtors and creditors” (62 “Settlements with buyers and customers”) - 172,280 rubles. — funds have been received from the buyer;
— Debit 91–9 “Balance of other income and expenses” Credit 99 “Profits and losses” — 11,216 rubles. — profit from the sale of the car is reflected.
Example. The lender organization provided the borrower organization with a cash loan in the amount of 326,000 rubles on July 1, 2021. for a period of 1 month. The interest rate under the loan agreement is 14% per annum. The terms of the loan agreement stipulate that interest under the agreement is paid simultaneously with the repayment of the loan amount.
In the accounting records of the lending organization, operations for granting a loan and calculating interest will be reflected as follows:
In July 2021:
- Debit 58–3 “Loans provided” Credit 51 “Current accounts” - 326,000 - funds provided under the loan agreement are reflected as part of financial investments;
- Debit 76, subaccount “Calculations for interest due”, Credit 91–1 “Other income” - 3876.27 rubles. — interest accrued due for July 2021 ((RUB 326,000 x 14%) / 365 days x 31 days).
In August 2021:
- Debit 51 “Account settlements” Credit 76 “Settlements with various debtors and creditors”, subaccount “Calculations for interest due” - 3876.27 rubles. — interest received under the loan agreement;
- Debit 51 “Current accounts” Credit 58–3 “Loans provided” - RUB 326,000. - the loan amount is returned.
Payment distribution
To distribute VAT on revenue, use the proportion of transactions subject to and non-taxable . The tax is deducted or included in the price of products and services (clause 4, clause 4, article 170 of the Tax Code of the Russian Federation).
If VAT is deducted, the proportion looks like this: ST (with VAT) / ST (total), ST (with VAT) is the price of products or services, the sale of which is subject to value added tax; ST (total) – the total price of goods or services sold in the tax period.
If the tax is included in the cost of products, then the following proportion is used : ST (excluding VAT) / ST (total), ST (excluding VAT) - the price of goods or services not subject to VAT; ST (total) – the total price of goods or services sold in the tax period.
The distribution of VAT on revenue does not include the following receipts:
- Interest on bank deposits and account balances.
- Profit on shares or shares in the authorized capital.
- Cash from payment of fines on loans and borrowings, violation of the terms of lending agreements.
- The discount rate charged by banks when purchasing bills of exchange.
- Cash received by subsidiaries from parent companies.
Attention! Expenses for the distribution of VAT include items of trade that participated in trade turnover on the territory of the Russian Federation. Production costs are necessarily taken into account in the cost of goods. The proportion must be drawn up strictly according to the regulations.
Classification of income in tax accounting
The concept of “income” in accounting and tax accounting is defined almost identically. For profit tax purposes, income is recognized as economic benefit in cash or in kind, taken into account if it is possible to evaluate it and to the extent that such benefit can be estimated.
Neither PBU 9/99 nor the Tax Code of the Russian Federation provides an explanation of the concept of “economic benefit”. This term is contained in the Concept of Accounting in the Market Economy of the Russian Federation, approved by the Methodological Council on Accounting under the Ministry of Finance of the Russian Federation and the Presidential Council of the Institute of Professional Accountants of the Russian Federation on December 29, 1997. In accordance with paragraph 7.2.1 of the Concept, future economic benefits represent the potential ability of property to directly or indirectly contribute to the flow of cash into the organization. An asset is considered to provide future economic benefits to the entity when it can be:
- used separately or in combination with another asset in the process of production of products, works, services intended for sale;
- exchanged for another asset;
- used to pay off an obligation;
- distributed among the owners of the organization.
For profit tax purposes, income from leasing property and granting rights to intellectual property for use can be taken into account both as part of income from sales and as part of non-operating income. At the same time, in accounting, income from participation in the authorized capitals of other organizations can be taken into account either as part of income from ordinary activities, if this is the subject of the organization’s activities, or as part of other income, when participation in the authorized capitals of other organizations is not the subject of the organization’s activities. For profit tax purposes, income from participation in the authorized capital of other organizations is classified as non-operating income of the organization.
Thus, the list of income from ordinary activities in accounting and income from sales for profit tax purposes can be formed in the same way, with the exception of income from participation in the authorized capitals of other organizations.
Non-operating income for profit tax purposes includes income that is not recognized as income from sales. The list of non-operating income is quite large. Nevertheless, the wording given in Article 250 of the Tax Code of the Russian Federation, that “non-operating income of a taxpayer is recognized, in particular, income ...”, allows us to conclude that the list remains open. We should not forget that not all funds and property received by an organization can be recognized as its income for tax accounting purposes (Article 251 of the Tax Code of the Russian Federation contains a closed list of income that is not taken into account when determining the tax base for income tax).
The list of income not taken into account when determining the tax base is much broader than the list of income not recognized as income in accounting. This leads to the fact that some income will be taken into account when determining accounting profit, but will not be taken into account when determining the tax base for income tax. In such a situation, you should be guided by PBU 18/02, approved by Order of the Ministry of Finance of Russia dated November 19, 2002 No. 114n, which establishes the procedure for reflecting and accounting for differences arising between accounting and tax accounting data.
When is trade turnover taxed and when is it not?
Four main groups of trade turnover subject to VAT are presented in the Tax Code of the Russian Federation:
- Paid or gratuitous sale of goods, services, labor, collateral in the Russian Federation, transfer of rights to property, to trade items on the basis of replacement of obligations by agreement of the parties or compensation, which is confirmed by paragraph 1 of paragraph 1 of Article 146 of the Tax Code.
- Sales of goods and services to meet the needs of the organization, but not for the purpose of making a profit. Such transfer of products is subject to VAT if the costs are recognized as economically unjustified or such costs are included in the item of expenses not taken into account when calculating income tax. Art. 252, Article 270 of the Tax Code of the Russian Federation.
- Carrying out construction and installation activities for your own needs. If an organization performs this type of work independently, then taxation is present (clause 3, clause 1, article 146 of the Tax Code). If the construction process is provided by a contractor, then there is no VAT.
- Import of trade items into the territory of the Russian Federation (clause 4, clause 1, article 146 of the Tax Code of the Russian Federation and clause 3, clause 1, article 2 of the “Customs Code of the Eurasian Economic Union”).
Revenue will not be subject to value added tax for manipulations that are not accepted as sales or are not subject to taxation. For example:
- Currency transactions (clause 1, clause 3, article 29 of the Tax Code of the Russian Federation). Transactions related to numismatics do not fall into this clause.
- Transfer of objects of ownership to the legal successor during the reorganization of companies (clause 2, clause 3, article 39 of the Tax Code of the Russian Federation).
- Return of assets to a person who was a member of a business company as part of the initial contribution in the event of termination of the company’s activities or withdrawal of a participant from its membership (clause 5, clause 3, article 39 of the Tax Code of the Russian Federation).
- Transfer of housing facilities, electrical networks, roads, etc. to authorities (clause 2, clause 2, article 146 of the Tax Code of the Russian Federation).
- Sale of land or land shares (clause 6, clause 2, article 146 of the Tax Code of the Russian Federation).
- Sale of property or rights to it in the event of bankruptcy of debtors (clause 15, clause 2, article 146 of the Tax Code of the Russian Federation).
There is also a closed list of processes named in paragraphs 1-3 of Article 149 of the Tax Code . Their peculiarity is that, being objects of taxation, they are not recognized as subject to tax and are exempt from VAT.
Goods not subject to VAT include:
- Approved list of medical products (clause 1, clause 2, article 149 of the Tax Code of the Russian Federation).
- Food products for medical organizations and canteens of kindergartens, schools, etc. (subclause 5, clause 2, article 149 of the Tax Code).
- Residential buildings and shares of premises in them (clause 22, clause 3, article 149 of the Tax Code of the Russian Federation).
Question of the week: revenue in form No. 2: without VAT or with VAT
Question: How is revenue reflected in Form No. 2: without VAT or with VAT?
I inform you the following:
In the Financial Results Report, the amount of revenue is indicated excluding VAT and excise taxes (clause 3 of PBU 9/99, note 5 in Appendix No. 1 to Order of the Ministry of Finance of Russia dated July 2, 2010 No. 66n).
In line 2110, show revenue for the year excluding VAT. It is equal to the difference between the credit turnover in subaccount 90-1 and the debit turnover in subaccount 90-3.
A selection of documents from ConsultantPlus Systems:
Document 1
In the Financial Results Report, the amount of revenue is indicated excluding VAT and excise taxes (clause 3 of PBU 9/99, note 5 in Appendix No. 1 to Order of the Ministry of Finance of Russia dated July 2, 2010 No. 66n).
Tax Guide. Practical guide to annual financial statements - 2021 {ConsultantPlus}
Document 2
How to fill out the 2021 income statement
The standard report form has been approved by the Ministry of Finance. In the report, provide data for 2021 and 2021. Show expenses and losses in brackets. For lines for which you do not have data, put dashes. So, all LLCs will have dashes in lines 2900 and 2910.
In line 2110, show revenue for the year excluding VAT. It is equal to the difference between the credit turnover in subaccount 90-1 and the debit turnover in subaccount 90-3. On line 2120, indicate the debit turnover for subaccount 90-2.
The gross profit or loss on line 2100 is the difference between lines 2110 and 2120.
In line 2210, indicate the debit turnover for the “Sales expenses” subaccount or another similar subaccount to account 90. In line 2220 - for the “Administrative expenses” subaccount.
Sales profit on line 2200 is line 2100 reduced by lines 2210 and 2220.
In line 2310, indicate the credit turnover under the “Dividends” sub-account to account 91, in line 2320 - under the “Interest receivable” sub-account. In line 2330 - debit turnover for the “Interest payable” subaccount.
Other expenses and income in lines 2350 and 2340 are any expenses and income from account 91, except interest, dividends and VAT.
Line 2300 “Profit (loss) before tax” is the profit or loss from sales from line 2200, adjusted for income and expenses from lines 2310 - 2350.
To line 2410, transfer the amount from line 180 of sheet 02 of the annual income tax return.
In line 2421, show the turnover for the subaccounts “PNA” and “PNA” to account 99. If PNA is greater than PNA, indicate the value in parentheses, if vice versa, without parentheses.
In line 2430 there will be the difference between credit and debit turnover on account 77. Indicate a positive result in parentheses, a negative result without parentheses.
In line 2450, indicate the difference between debit and credit turnover on account 09. Indicate a positive result without parentheses, a negative result in parentheses.
In line 2460, show in a collapsed manner other income and expenses that are immediately attributed to account 99, for example, penalties and interest on taxes.
To calculate net profit in line 2400, adjust the profit or loss before tax from line 2300 to the values of lines 2410, 2430, 2450 and 2460. To check, compare the amount from line 2400 with the turnover on account 99 in correspondence with account 84 - they should be equal.
Data for lines 2510 and 2520 are usually not available, so the total financial result on line 2500 is equal to the net income or loss on line 2400.
{Typical situation: How to fill out a financial performance report for 2021 (Glavnaya Kniga Publishing House, 2019) {ConsultantPlus}}
Step-by-step instructions: how to plan sales income and costs in Excel
An Excel spreadsheet is used to plan revenue and production costs . The standard table for calculating efficiency has four fields:
- Tax rates (cell A1:B3).
- Income from the sale of trade items, expenses and debit VAT (A5:B7).
- Determination of value added tax for payment to the budget (A9:B10).
- Calculation of revenue and taxes on profit and turnover (A12:B17) (find out the main differences between revenue and turnover here).
Information is entered into the first two fields, and the next two fields process it.
- The type of calculation of the tax liability for VAT according to the table is as follows: =ROUND(B5*(B1/(1+B1));2).
- To calculate the amount of tax to be paid to the state treasury, you need to subtract the amount of the tax credit from the amount of tax liabilities (B10) = B9-B7.
- GP (gross profit) excluding VAT (cell B12) is calculated by subtracting the value of tax liabilities from the amount of revenue = B5-B9.
- Sales revenue is determined by subtracting costs = B12-B6 from the amount of VP.
- To calculate the turnover tax, VP is multiplied by the turnover tax rate = ROUND(B12*VZ;2).
- Revenue subject to taxation is the difference between the realized profit and the amount of turnover tax = B13-B14.
- Revenue tax is the product of the amount subject to taxation and the income tax rate, the result is rounded to the second digit = ROUND(B15*B2;2).
- Net profit is calculated by deducting the amount of income tax from taxable income = B15-B16.
Using an Excel spreadsheet is convenient because by changing the tax rate data, you can easily adapt to the current tax system. After changing the values of costs and sales amounts, the final result is immediately reflected. Excel offers various methods for entering data, in addition, formulas and a variety of functions provide additional possibilities for calculations.
We recommend that you pay attention to other publications by our experts, after reading which you will learn:
- How does revenue differ from cost, income and profit?
- How to calculate annual revenue?
- What are the reasons for the decline in revenue and how can it be increased?