For registration of retail sales through ATT in 1C 8.3, we will use the document Retail sales (checks). This document is located in the section Sales→Retail sales (checks). Each sale in 1C 8.3 is documented as a separate document:

Let's take a look at this document. In the header of the document, we indicate on behalf of which organization, at which outlet the sale is carried out. And also indicate at what type of price the product will be sold:

The tabular part contains four tabs:

• Goods and services;
• Agency services;
• Sale of certificates;
• Cashless payments.

When placing sales, select the necessary bookmark.

Example 1. LLC "Success" 10.07.2016 sold to a retail customer Dining table in the amount of 1 pc. at a price of 2,000 rubles. and provided a service for the delivery of goods by its own transport.

Select the Goods and Services tab and fill in the required nomenclature. After filling in the tabular part to fix the payment in cash, press the button Accept payment. In the window that opens, in the field Cash indicate the amount received from the buyer:

If the amount received exceeds the amount of payment, then the program 1C 8.3 calculates the change. If you need to immediately print a sales receipt, check the box Print a sales receipt. And we press the button Accept payment in the window Payment. Everything, the sale to the buyer is completed, the sales receipt is printed on the printer:

If the sales receipt was not printed at the time of registration, then it can be printed later either from the document journal Retail sales (checks) by button Seal, having previously selected the necessary document:

Or using the Sales receipt button inside the document Receipt:

If payment is made by bank transfer

If payment will be made by bank transfer, then select the tab Cashless payments. Choose from the directory Payment type and enter the payment amount. If the required type of payment is not in the directory, then it must be created. When creating, select a payment method from the list:

If payment is made in a combined way - for cash and cashless payments

One check can be paid in different ways. For example, part by bank transfer, part by cash, or by certificate and by bank transfer, and so on. With a combined payment method in 1C 8.3, first indicate Cashless payments, on the appropriate tab, then click on the button accept cash in document Receipt in the window Payment select cash and indicate the total amount of the check:

With this method of payment, cash will be reflected in the debit of account 50.01, and non-cash - in the debit of account 57.03:

To summarize retail sales per day in 1C 8.3, a document is drawn up at the end of the day . Chapter Sales → Sales → Retail sales reports:

Gift certificates in retail

To sell gift certificates, both your own and third-party, as well as the possibility of accepting payment with certificates, you must set the appropriate settings in the 1C 8.3 program. Chapter Main→ Settings→ Program functionality:

Create payment types, specify the name of the certificate. In the counterparty field, you can specify a generalized buyer, for example, Retail. In the contract field, you can specify Without contract:

Issuing a check is identical to issuing a check when selling goods. Same as when selling goods on a bookmark Sale of certificates indicate which certificate is sold and how payment will be made. The sale of the certificate is completed:

Agency services for retail trade in 1C 8.3

If the organization acts as an agent, then on the Agency services tab, the services are indicated, in the implementation of which the organization acts as an agent.

Let's take the conditions of example No. 1, but the delivery of goods will be carried out not by Success LLC, but by the transport company Luch LLC. An agency agreement was concluded between the organizations, according to which Success LLC, on its own behalf, implements the delivery service provided by Luch LLC.

When issuing a check for sale in 1C 8.3, except for the bookmark Goods and services, in this case, the bookmark is also filled Agency services. On the tab, we indicate information about the service, the cost of the service and the counterparty with which the agency agreement has been concluded. Payment information is indicated in the same way as when selling goods or certificates:

We recommend that you watch our seminar, which discusses how 1C 8.3 reflects expenses of an administrative and managerial nature in trade organizations, on which account such costs should be taken into account, and what settings need to be made in 1C 8.3 so that at the end of the month such costs are automatically debited to account Dt 90 .

document Retail sales report in 1C summarized for the period are reflected. After the document is posted, the nomenclature listed in it will be deregistered. You can find this document in 1C 8.3 in the section Sales → Sales → Retail sales reports:

The retail sales report in 1C 8.3 is created:

• Automatically as a result of an operation close shift;
• Based on document Inventory of goods;
• Can be created manually.

How to make a Retail Sales Report when selling through an automated point of sale (ATT) in 1C 8.3

In 1C 8.3, retail sales in a retail store (ATT) or from a wholesale warehouse are documented Retail sales (checks). In this case, each sale is recorded by a separate check.

Example

In a retail store (warehouse "Store Warehouse No. 2"), 06/20/2016 During the shift, three checks were broken:

• Receipt No. 1 sold: zipper 20 cm - 2 pcs. and threads - 1 pc.;
• Receipt No. 2 sold: buttons - 5 pcs. and a ballpoint pen - 1 pc.;
• Receipt No. 3 sold: ballpoint pen - 3 pcs.:

At the end of the working day in the store or at the time of closing the checkout shift, you must perform the operation close shift. This operation in 1C 8.3 is available in the document journal Retail sales (checks):

As a result of this operation, documents are automatically generated in 1C 8.3 Accounting 3.0:

• Retail sales report;
• Cash inflow with transaction type - Retail revenue:

Each of these documents will be reflected in its journal. In 1C 8.3, these documents are generated, recorded, but not carried out. It is necessary to check the correctness of filling in the information in the created documents. If we make sure that all the information in the documents is filled out correctly, then we will conduct them:

Document Retail sales report the same nomenclature will be written in one line, taking into account returns. In our example, this "Ballpoint pen". This nomenclature was punched in check No. 2 in the amount of 1 piece, and in check No. 3 in the amount of 3 pieces. Since there were no returns during the day, we see in the report that 4 ballpoint pens were sold.

Document Cash flow reflects the total total revenue from punched checks, taking into account the return.

How to reflect the return of goods in the Retail Sales Report

As noted above, when automatically generating a document Retail sales report 1C 8.3 takes into account all returns made during the cash register shift.

Let's look at this situation with an example. To do this, we will use the data of the example above and assume that according to check No. 2, the product “Ballpoint pen” was returned in the amount of 1 pc. Return to 1C 8.3 is reflected in the document Check (Refund):

After posting this document in the journal Retail sales (checks) a check with the type of transaction will be displayed Return:

Let's close the cash register shift and see that the report reflects sales, taking into account the return. Namely, the product "Ballpoint pen" was punched in check No. 2 in the amount of 1 pc., and in check No. 3 in the amount of 3 pcs. and was returned in the amount of 1 pc. Therefore, in the report we see that 3 ballpoint pens were sold:

How to make a Retail Sales Report "manually"

Consider the option of manually filling out a retail sales report in 1C 8.3 Accounting 3.0. This option is used when in 1C 8.3 each sale is not documented as a separate document Retail sales (checks), and the sales are immediately recorded in the Retail Sales Report document.

Using the data from the example above, let's fill out the document manually by doing the following: section Sales → Sales → Retail Sales Reports → Report → Retail Store:

Using button Pick up fill in the document table:

Document Cash flow with this registration of retail sales, it is also necessary to register manually. This can be done using the mechanism Create based on. The created document will reflect the total revenue for the document Retail sales report:

How to fill out a Retail Sales Report when selling through manual outlets (NTT) in 1C 8.3

A manual outlet in 1C 8.3 is a store where sales data is not entered daily.

Document execution Retail Sales Report to reflect sales in NTT depends on how sales information is received in accounting. Information can be submitted in two ways:

• Information about the sold goods is provided;
• An inventory is being carried out.

Both can be done daily or at intervals specified in the organization's workflow. Let's consider both methods.

Method number 1

In the accounting department, for example, information about the goods sold is submitted daily. In this situation, in 1C 8.3 we draw up a document Retail sales report. Chapter Sales → Sales → Retail Sales Reports → Reports → Manual Point of Sale:

In the header of the document, select the warehouse. In the tabular section, using the Add or Selection button, indicate the product sold per day. Document ready:

Method number 2

Let's assume that the organization does not report sales, but takes inventory of the warehouse every three days. Then the actions in 1C 8.3 will be as follows:

• Retail revenue coming in;
• We take inventory of the warehouse. We form the document Inventory of goods;
• We draw up a document Retail sales report on the basis of the inventory document .

In the inventory document, we indicate the actual balance of goods in the warehouse. Lines where the actual quantity does not match the booked quantity show a variance. Deviation and will reflect sales:

Using mechanism Create based on, we form the document Retail sales report:

Whether all this product was really sold or part of it is missing, the 1C 8.3 program will check during the document Retail sales report, since before posting this document, it is necessary to capitalize retail revenue. Otherwise, it will not be possible to post the Retail Sales Report document in 1C 8.3:

If the credited revenue does not match the amount indicated in the report, then this report on retail sales in 1C 8.3 is not carried out. Therefore, it is necessary to find out the reasons for the discrepancy:

Accounting for retail sales is one of the most common operations in trade. Retail sales in 1C 8.3 Accounting are recorded using a special document - a report on retail sales. The completion of this report can be automated, or you can generate it manually. How to fill out a retail sales report in 1C 8.3, read this article.

When selling goods at retail in accounting, it is necessary to reflect several operations at once:

• Receipt of funds from the buyer (cash or non-cash);
• Reflection of proceeds from the credit of account 90;
• Write-off cost of goods sold.

In 1C 8.3 Accounting there is a special document that generates these operations - a report on retail sales. There are two ways to create it:

1. In automated mode
2. In manual mode

If the store has equipment and software that captures all the goods movement online, then such an outlet is considered automated. In this case, using special 1C software, you can automatically generate a retail sales report in 1C 8.3.

If the store does not have equipment for detailed sales accounting, then such an outlet is considered non-automated. The report on retail sales in such cases is done manually, or on the basis of inventory. As a rule, stalls, kiosks and small shops are non-automated points.

In 1C 8.3 Accounting in the "Warehouse" directory for each outlet, you need to select one of two types of warehouses:

1. Retail store;
2. Non-automated outlet.

For stores with automated accounting, choose the first type of warehouse. For other points of sale, select the value "Non-automated point of sale".

How to make the necessary settings in 1C 8.3 Accounting in a few steps and fill out a retail sales report, read in this article.

Quick transfer of accounting to BukhSoft

Step 1. Set up 1C 8.3 Accounting for retail

To account for retail in 1C 8.3 Accounting, you need to make some settings. To do this, go to the "Administration" section (1) and click on the "Functionality" link (2).

In the window that opens, go to the tab "Trade" (3) and check the box next to the inscription "Retail" (4). If necessary, also check the boxes next to the words "Gift certificates" (5) and "Alcohol products" (6). Now the 1C 8.3 Accounting program is ready for retail accounting.

In retail, there are two ways to account for the valuation of goods:

• By acquisition cost;
• At the selling price, using account 42 "Trade margin".

In the accounting policy of the organization, you must set one of the methods. To do this, go to the "Main" section (7) and click on the link "Accounting policy" (8).

In the window that opens, specify your organization (9) and select one of the assessment methods:

• “By acquisition cost” (10);
• "By selling price" (11).

The necessary settings are made, you can start accounting for retail transactions.

Step 2: Manually generate a manual POS report

If your store is not equipped with an automated sales accounting system, then you can generate a retail sales report in 1C 8.3 Accounting manually. To do this, go to the "Sales" section (1) and click on the link "Retail sales reports" (2).

In the window that opens, you see a list of previously created documents. Click the "Report" button (3) and select the "Manual POS" link (4). A form for creating a document will open.

In the window that opens, specify:

• Formation date (5). If the report is generated over several days, put the last date of the period;
• Your organization (6);
• Warehouse (Outlet) (7). A separate warehouse is created for each point. We remind you that the type of warehouse in this case should be "Manual outlet";
• Article DDS (8). Select the "Retail Revenue" value from the directory.

In the commodity part, fill in:

• Sold goods (9);
• Its quantity (10);
• Selling price (11);
• VAT rate (12).

To execute, press the button "Post and close" (13). The document will be posted only if incoming cash orders or payment card transactions were created during the reporting period. Moreover, the amount in the report must match the amount of cash payments and card transactions. If the amount of payments for the reporting period is 140,000-00 rubles, and the amount of goods sold in the sales report is 145,000-00 rubles, then when posting the document, an error message will appear: “Available retail revenue for sales: 140,000, required: 145,000. Missing the revenue must first be credited with the Cash receipt document.

Now the document has appeared in the general list of reports. When it is carried out in accounting 1C 8.3 Accounting, postings are formed to write off the cost of goods sold. Postings are also created on the off-balance accounts of the RV “Retail revenue” and postings for adjusting revenue on account 90 “Revenue” (postings for the total amount are reversed and new ones are formed, broken down by nomenclature and quantity).

Step 3. Create an Inventory Report

You can generate a sales report for a manual point of sale from an inventory document. This document automatically calculates the accounting quantity of goods on the inventory date. It also manually indicates the actual number of goods identified as a result of the recount. The difference between the booked quantity and the actual quantity will be transferred to the retail sales report. Next, read how to create such a report in 1C 8.3 Accounting.

Create an inventory of goods in 1C 8.3

Go to the section "Warehouse" (1) and click on the link "Inventory of goods" (2). A window with previously created inventories will open.

In the window that opens, click the "Create" button (3). An inventory form will open.

In the "Inventory of goods" window, specify:

• Inventory date (4);
• Your organization (5);
• Point of sale (warehouse) (6);
• Responsible person (7).

Now in the commodity part in the field "Accounting Quantity" (10) we see the balances according to accounting data. In the "Actual quantity" field (11), manually enter the actual number of goods on the inventory date. After that, in the "Deviation" field (12), the quantity of goods sold will be automatically calculated. To conduct an inventory, press the "Record" (13) and "Perform" (14) buttons.

Generate Retail Sales Report from Product Inventory

To create a sales report, click the "Create based on" button (15) and select the link "Retail sales report" (16). The completed sales document will open.

In the document that opens, enter the correct date (17), check the quantity sold (18) and the selling price of the goods (19). To reflect sales in accounting, click the Post and close button (20). Now in accounting there are postings for writing off the cost of goods sold. Postings were also generated on off-balance accounts of RV "Retail revenue" and postings for adjusting revenue on account 90 "Revenue".

Step 4: Create a retail sales report for an automated point of sale

If your store is equipped with an automated sales accounting system, then the retail sales report in 1C 8.3 Accounting is generated automatically. To see it, go to the "Sales" section (1) and click on the link "Retail Sales Reports" (2). A list of previously created documents will open.

There are two types of reports in the list:

• With the type of operation "Retail store";
• With the type of operation "Non-automated outlet".

In automated point of sale reports, the transaction type should be "Retail store" (3). This report, as we have already said, is automatically loaded into 1C 8.3 Accounting. The download schedule depends on the software of your store. Before running a report, go into it and check all the data. To enter it, double-click on it in the general list of reports (4).

In the report that opens, check the date (5), point of sale (warehouse) (6), quantity (7) and sales price (8) of the goods sold. In the lower part of the window, check the total amount (9) with the amount of payment received for the report period. These two figures must be equal. After verification, swipe the document. To do this, click the "Post and close" button (10). Now in accounting there are entries for writing off the cost of goods sold and for recording revenue. Also, the report on retail sales for an automated point of sale generates postings for the receipt of cash payments. In this it differs from a report on a non-automated point of sale, where payment entries are generated by the receipts.

You can also create a report for an automated outlet manually, similar to a report for a non-automated outlet.

Attention is important! As we have already said, the report on retail sales for an automated outlet itself generates postings for the receipt of cash payments. In order for these payments to be reflected in the cash book, you must create an incoming cash order. At the same time, in order not to double the accounting entries for the receipt of money, in the incoming cash order in the field “Type of operation”, you must specify “Retail revenue”. In this case, the recipient will not generate accounting entries, but will be reflected in the cash book.

Send this article to my mail

In order to effectively manage retail businesses, like any other, it is necessary to have aggregated, up-to-date and accurate information. In this article, we will consider the Retail Sales Report document in 1C Retail. We can say that it is a generalizing document on the cash register shift, containing data on the quantity of goods sold, prices, discounts and other information, and also, in turn, it is part of the sales registration scheme. Registration of sales is carried out using the documents "Check KKM". You can make a sale in the program either from the KKM Check, or in a special interface developed for this, which is called the RMC. Payment is possible in several ways: cash, gift certificate, bank card, credit, bonuses. Combined payment is also possible, when, for example, part of the goods is paid for by a certificate, and part is paid in cash. Then, when the shift is closed, a report on retail sales will be automatically generated based on receipts.

This document also generates the corresponding postings, which provide for the write-off of the cost of goods sold at a certain sale value. If necessary, changes can be made in the form of reversal documents.

There are several ways to create a Retail Sales Report document in 1C Retail. The first way is to create a document manually, from scratch. The second way is based on the inventory document. And the third way - automatically, as already described above. This method is usually used most often in work.

If you have questions about the retail sales report in 1C: Retail, ask them in the comments below the article, our experts will try to answer them.

Let's consider the third method in more detail. Let's open a cash register shift from the "Receipts" document list form in the "Sales" section for the selected cash desk.

After that, go to the “Products” tab and add a list of three items of household appliances.

Since the buyer took a set of equipment from three items, he is entitled to a discount, which was calculated on the corresponding “Discounts” tab.

And the payment was made. Part of the amount was paid in cash in the amount of 20 thousand rubles. and the rest paid on the card in the amount of 49958 rubles.

After that, it remains to carry out the document. Let's create one more check according to the same principle and sell the "Bag". The price with a 1% discount for the buyer will be 1980 rubles. Payment was made in cash. Next, we will close the cash register shift.

At the end, a message should appear stating that the cash register shift is closed and the report will be generated automatically. Next, we return to the sales section and select the “Retail Sales Reports” item and open the last document in the list.

On the “Goods” tab, we see all the goods from the created checks.

Also a total cash payment on two checks.

And on the next tab payment by payment cards. If necessary, by clicking the "Print" button, you can print the desired printed forms.

These printables will contain the total amount and quantity of each item sold.

A team of experienced 1s-programmers:

From 5 minutes response time to urgent tasks, even on weekends and holidays.

30+ programmers with up to 20 years of experience in 1C.

We make video instructions for completed tasks.

Live communication through any messengers convenient for the client

Control of the execution of your tasks through a specially developed application

Official partners of 1C since 2006.

Experience in successful automation from small firms to large corporations.

99% of clients are satisfied with the results

We propose to consider how the process of retail sales takes place in a non-automated outlet based on the program 1C 8.3 Accounting, edition 3.0.

A non-automated outlet (NTT) is a retail facility that does not have the ability to directly access the 1C database. This could be a retail store, kiosk, marketplace, or outreach.

Reflection of retail sales involves the creation of several related documents. This:

Receipt of goods.

Price setting.

Move.

Sale from a retail warehouse in NTT.

Collection or receipt of proceeds.

Retail goods are sold from a retail warehouse. Where it gets by moving from the wholesale warehouse. Let's first analyze the receipt of goods. This process is registered by the document "Receipt of goods and services". The following fields are filled in the header:

Invoice No. - supplier's document number.

Original received - check the box if the supplier has presented the original documents for the supply of goods.

Number and date - are formed automatically in order.

Organization - if one organization is registered in the accounting policy of the 1C program, then the field is filled in automatically or is absent. And if accounting is maintained, for example, remotely via 1C in the cloud for several organizations, then we select the required company from the directory.

Warehouse - indicate which warehouse the consignment of goods falls to, is selected from the directory. As a rule, this is the "Main Warehouse" or "Wholesale Warehouse".

A counterparty is a supplier organization. Choose from the directory of contractors or create a new one.

Agreement - is substituted automatically after selecting a counterparty.

Invoice for payment - selected from the journal, if it was previously issued. If not subscribed, then the field remains empty.

Settlements - this item can be configured depending on the type of settlements with the counterparty. Just click on the link and specify the desired type.

The consignor and consignee is a link, by clicking on which it is possible to specify or change information. It is used when the data differs from the declared ones.

An item with VAT is displayed automatically based on the parameters entered in the counterparty card and accounting policy.

The tabular part of the document can be filled in any of the following ways:

Through the "Add" button. Each product is individually selected from the nomenclature and the quantity is manually specified.

Through the "Select" button. In this case, goods with the required quantity are selected from the nomenclature and transferred to the document in bulk.

After adding the product, if necessary, you can specify information in the columns "Custom declaration number" and "Country of origin".

After entering all the data, we check and carry out. If the supplier has provided an invoice, you must register it by entering the number and date in the appropriate field at the bottom of the document. The item has been credited. Now you need to set the price at which it will be sold. To do this, there is a special document "Setting item prices". It is located on the Warehouse menu tab. The document is filled out manually. The 1C program has the ability to massively set prices directly from the receipt document, which is very convenient and saves time. We go into the created document "Receipt of goods and services" and press the "Create based on" button. In the drop-down list, select the item "Set item prices". A form will open filled with basic data. All you need to do is select the price type in the corresponding field.

On the basis of the receipt, you can create several documents "Setting item prices" with different types of prices (if it is not possible to enter all the necessary types of prices).

The form has an item "Register zero prices". If the checkbox is checked, then it is better to uncheck it. Otherwise, for goods for which a new cost has not been established, a price with the value "0" will be registered. It is unacceptable.

You can correct the price value (increase or decrease by %) using the "Change" button. The cost of the goods is assigned, it can be moved to the outlet. It can be NTT or a trading floor. The process is formalized through a special document "Movement", the log with which is located on the menu tab "Warehouse". This is useful if you need to move a small number of positions. During a mass transfer, a “Movement” is usually formed from the receipt document through the “Create Based on” button. All filling takes place according to the document-base, it remains only to set the type of the recipient warehouse and manually enter the number of items to be moved.

Based on the receipt, you can create several Transfer documents to different warehouses. The quantity is edited manually. If you suddenly made a mistake and indicated more than what is in stock, the program will generate an error displaying the name of the product.

Now you can sell the goods. If sales are carried out from the “Trading Room” warehouse, then at the end of the working day, a “Retail Sales Report” is generated. All sold items will be listed here. The report is created for the warehouse, which you need to select yourself, reflecting the revenue:

Fields to be filled in:

Warehouse – for which warehouse the report is generated.

Article DDS - it is necessary to indicate "Cash receipt retail revenue".

Cash account - an account for which revenue is recorded.

If necessary, you can enter the "Account Account" and the Income Account, if not automatically substituted, and subconto.

To report retail sales at a manual outlet, you must first take inventory. We go to the menu tab "Warehouse" and select the item "Inventory of goods". The document header indicates the warehouse and organization. Adding goods in bulk is carried out through the "Fill" button. From the drop-down list, select "Fill with inventory balances". The tabular section will display the entire nomenclature that is listed in the specified warehouse. After recounting the goods, the existing balance is entered in the column "Actual Quantity". The column "Deviation" will reflect the amount of goods sold.

After the inventory, directly from the document, through the "Create Based on" button, we form the "Sales Report". But the report will not be carried out until the receipt of revenue is registered in 1C. To do this, go to the menu tab "Bank and cash desk" and form the document "Cash receipt".

Fill in the fields:

The type of operation is retail sales.

Warehouse – which warehouse was used for sales.

Amount - the amount of revenue.

In the tabular section, add a line indicating the amount of payment and the article DDS.

We carry out the document. After that, we return to the sales report and post it.

Converter