Excel – Business Book of Income and Expenditure (PK-1) includes recording income from sold products, goods, materials, and services, extraordinary income, income from financing, as well as all operating expenses related to that period of the business. Postings in the business book of income and expenses are performed neatly and accurately on the basis of authentic documents such as payment slips, payment orders, transfer orders, invoices, fiscal cash register control tapes, and other documents.
Excel Business Income and Expense Book PK-1 Form
If the entrepreneur performs the activity in several business units (shops), the business book of income and expenses is kept for the total activity, ie. activities. The data from the KL form, which we processed in the Calculation of the selling price of goods in Excel, are taken into this business book.
Recording data in PK-1 form
Like any business book, PK-1 in its upper left corner must contain basic information about the entrepreneur, namely: PIB, name, and surname of the taxpayer, company shop, address (headquarters) of the taxpayer, taxpayer code, and code activities.
Excel The business book of income and expenses is kept throughout the year, but at the end of the business year, in order to express the financial result, data is collected from all columns and their sum is expressed as a subtotal before closing the business books, as follows:
In column 1 – The ordinal number of the business change from the beginning of the year, ie from the beginning of the activity, if that beginning is in the current year; this ordinal number is entered in the upper right corner of the accounting document on the basis of which the posting is a business change;
In column 2 – Date of posting the business change in the business book;
Column 3 – Description of posting (name, number, date) of the business change, name, number, and date of the accounting document on the basis of which the business change was posted;
Revenue Recording in Excel
In columns 4, 5 and 6 – income from trade in goods and services, as follows: entrepreneurs – VAT payers who perform the activity of trade in goods in retail, and in commissions, based on data (fiscal statement, invoice, etc.) on trade in goods, enter the amount of taxable turnover with calculated VAT, provided that in column 4a (At the general rate) they enter the amount of taxable turnover with calculated VAT for performed turnover at the general rate, and in column 4b (At special rate) enter the amount of taxable turnover with calculated VAT for performed turnover at the general rate feet; Entrepreneurs – VAT payers who sell goods in bulk and producers of goods who sell their products from the warehouse enter data sorted by rates in columns 4a (At the general rate) and 4b (At a special rate) with calculated VAT, provided that the classification is based on data from invoices, ie other documents on the sale of goods; entrepreneurs who are not VAT payers enter data on turnover of goods in column 5 (Goods without VAT); Entrepreneurs – VAT payers who perform services and catering activities that provide food and beverage consumption services on the spot in column 6a (VAT services) enter the value of services performed based on data from the fiscal section and invoices for services performed with calculated VAT, and entrepreneurs non-VAT payers enter data on services rendered in column 6b (Services excluding VAT);
In column 7 – Other revenues by types of revenues in accordance with the law governing accounting and auditing and bylaws governing the chart of accounts and the content of revenues in the chart of accounts for companies, cooperatives, and entrepreneurs (account groups 63-69);
In column 8 – the sum of revenues (Total revenues) from columns 4 – 7;
VAT recording in Excel
In column 9– (Calculated VAT) filled in by the entrepreneur-VAT payer, the amount of calculated VAT for delivered goods and services is entered;
In column 10 – (Preliminary VAT) filled in by the entrepreneur-VAT payer, the amount of previous tax stated in the invoices for delivered goods and services is entered;
In column 11 – (VAT paid), which is also filled in by the entrepreneur-VAT payer, the data on the amount of paid VAT is entered; this data is entered on the basis of the order on the payment made after the submitted application in accordance with the regulations governing VAT, for the tax period; if in the tax period the amount of previous tax is higher than the amount of calculated tax for delivered goods and services, the amount from the order for which the refund was made shall be entered in this column, provided that this amount is recorded with a red cancellation (-);
Expenditure recording in Excel
In column 12 – (Purchase value) entrepreneurs-VAT payers enter the purchase value of goods (net invoice value and direct purchase costs), spare parts intended for sale (servicing), the purchase value of reproduction material, the value of reproduction material, the purchase value of alcoholic beverages and groceries in catering (from the supplier’s invoice), etc .; VAT payers who sell goods to the commission enter in column 12 the value of goods or products that are paid to the customer under the contract; stated VAT in the supplier’s invoices is entered in column 10 – previous VAT; entrepreneurs who are not VAT payers enter the purchase value in column 12 with the previous VAT stated in the supplier’s invoices;
In column 13– (Retail trade) entrepreneurs-VAT payers enter the value of their own products without VAT (except for caterers), if these products are sold to final consumers; catering activities in column 13 enter the value of food and beverages on the spot; entrepreneurs who are not VAT payers enter the value of their own products without VAT in column 13;
In column 14 – (Difference in price) entrepreneurs who perform catering and trade activities enter the amounts of differences in the price of column 8 from the records of KL (calculation of sales price); during the leveling of the price of goods, the amount of increase or decrease of the selling price is entered, and in case of reduction of the price, the amount of that decrease is marked with the sign “reversible” – rounding the amount and subtracting from the sum input. the amount of the difference in the price of column 8 from the records of the KR (record sheet of the commission goods);
In column 15– (Calculated VAT) entrepreneurs-VAT payers who perform retail trade activity, commission sales or put their own manufactured products on the market to end consumers, enter the amount of calculated VAT from column 11 of KL records or the amount of VAT, which are obtained. (which consists of the product of the quantity from column 6 and the amount of the selling price from column 8 from the records on finished products) and the prescribed VAT rate or the amount from column 9 from the record sheet of the commission goods;
in column 16 – (Sales value) the sum of the amounts from columns 12, 14, and 15 or the sum of the amounts from columns 13 and 15; Entrepreneurs who perform catering activities in this column transfer the amount from columns 13, and entrepreneurs who perform craft and other activities and sell their own products to end consumers at retail, enter in this column the sum of sales values of products from column 13 and the amount of calculated VAT from column 15;
In columns 17-19 – (Personal expenses; Intangible expenses; Financial expenses) expenses are in accordance with the law and bylaws governing the chart of accounts and the content of accounts in the chart of accounts for companies, cooperatives, and entrepreneurs; by type of expenditure as reported by the groups of accounts listed in those columns; Entrepreneurs-VAT payers enter in these columns the net value from the supplier of the invoice without stated VAT and enter the stated VAT in column 10, and entrepreneurs who are not VAT payers enter the value from the supplier of the invoice with VAT included;
In column 20 – total expenditures (Expenditures), as the sum of the amounts from columns 12, 17, 18, and 19;
Recording computer statements in Excel
In column 21 – (Paid; Paid) data on the turnover on the company’s account according to the statement of changes and balance on the bank account, with the amounts of payments made to the account being shown separately, and especially the amounts of payments made.
Posting business changes to Excel
Business change includes all changes that occur and affect the value of assets, financial liabilities, changes in the amount of capital, changes in the amount of income, expenses, etc. A credible accounting document is required for each recorded change in the business book. For entrepreneurs who keep simple bookkeeping, it can be Initial balance, Entry calculation, Return to the supplier, Own product, Price leveling, Excess in stock, Shortage in stock, Output invoice, Return of goods from the customer, Daily market, Daily market cancellation, VAT payment, Invoice costs, Incoming invoice, etc.
Download excel file
CONTINUED TO FOLLOW!