Advance report in 1s 7.7. Advance report. Deadlines for the advance report, confirmation of expenses and daily allowance

Although not very often, there are still organizations working with 1C:Enterprise 7.7. The language of this version is seriously different from the language of 1C:Enterprise 8, so even creating a simple report can be a problem for a person who has not worked with 1C 7.7 (like me). I found little information on the Internet, mostly everything refers to the ZhKK (yellow-red books of manuals), so I will try to summarize everything I found in this article. I will describe creating a report without using constructors, although they can simplify the task.

So, the task: create a report - a register of invoices for metal (the organization is engaged in accepting scrap). The register is a table with the number and date of the invoice, the name of the metal, etc. The content is not so important, it is important that we receive the data by querying the document Receipt of goods and its tabular part. The user will be able to set filters for the report by date, by warehouse and by type of metal (ferrous or non-ferrous).

Create a report

1. Let's create a report. Mine will be called JournalPSA. This is done in the same way as in 1C 8. When you open a created report, its form is immediately displayed. Below on the tabs except mode Dialogue there are modes Module and report layouts. Layouts can be added by clicking right click at the tab level and selecting Add a table.
2. In mode Dialogue We add input fields into which data for filters will be entered. Similar to 1C 8, there are controls on the bottom toolbar. When adding an input field, a properties window will open in which you need to specify Identifier And Data type. The identifier is Name element from which the user-selected value can be obtained. So I added the following fields: Select Beginning of Period, Select End of Period, Select Metal, Select Storage Location. We will also need a button Form, most likely it already exists. Let me just draw your attention to the parameter Formula in its properties. The name of the procedure that is called by pressing the button is written there. That is, for example, Generate().
3. Create a report layout. Everything here is similar to the layouts in 1C 8. The same spreadsheet document in which there is sections(they are also regions). Section names are assigned through the menu Table. Cells have several types of filling, which are similar to the types in 1C 8: text, parameter, template. Only parameter called here Expression. There is also a difference from 1C 8. Parameter expressions here are not assigned names, but the name of the variable from which the value must be taken for substitution in the layout is written. For example, my request will receive the invoice number, so in the properties of the corresponding layout cell with type Expression I will write Request.Number. The template works the same way as in 1C 8. The text part is written as usual, and the expression is enclosed in square brackets. And it must also contain a variable from which the value is taken. For example, I need to derive the level of radioactivity of accepted scrap from the query result and add a unit of measurement to the number µSv/h. The following template is suitable for this: [Request.radiation] µSv/h
   
   
4. Now let's move on to the report generation procedure. Most likely the procedure for the button Form has already been created, if not, create it manually. The code will look like this:
   

   Procedure Generate()
   Variable Query, Query Text, Tab;
   //Creating an object of type Request
   Request = CreateObject("Request" ) ;
   RequestText =
   "//((REQUEST(request)
   |Period from SelectStartPeriod to SelectConPeriod;
   |Process NotMarkedForDeletion;
   |No results;
   |Number = Document.Receipt of Goods.DocNumberIncoming;
   |Date = Document.Receipt of Goods.DateDocIncoming;
   |Deliverer = Document.Receipt of Goods.Counterparty.Name;
   |Legal Address = Document.Receipt of Goods.Counterparty.Legal Address;
   |DocumentSeries = Document.Receipt of Goods.Counterparty.DocumentSeries;
   |DocumentNumber = Document.Receipt of Goods.Counterparty.DocumentNumber;
   |DocumentIssued by = Document.Receipt of Goods.Counterparty.DocumentIssued by;
   |Metal = Document.Receipt of Goods.Goods.Metal;
   |Weight = Document.Receipt of Goods.Quantity;
   |Radiation = Document.Receipt of Goods.Radiation;
   |Storage Location = Document.Receipt of Goods.Storage Location;
   |GroupDocumentLine;
   |Grouping Document;
   |Condition(Metal.Non-ferrous = SelectMetal);
   |Condition(StorageLocation = SelectStorageLocation);
   |" //))REQUEST
   ;

   The text of the request, I think, is clear. To form it, you can use the query builder (top menu Constructors). Let me draw your attention to some features:

   • Each request field is recorded in a separate variable; they can be seen before the = sign. This is basically the same as setting aliases in .
   • In request Necessarily there must be at least one group. Otherwise, it will be impossible to bypass the query result. IN in this case The grouping occurs first by the lines of the Goods Receipt document, and then by the documents themselves. If you leave only document lines in the grouping, one document will be displayed.
   • The request can take data from the form. For example, the condition StorageLocation = SelectStorageLocation indicates that the value will be taken from the input field named SelectStorageLocation.

   // If there is an error in the request, exit the procedure
   If Request. Execute(QueryText) = 0 Then
   Return;
   EndIf ;

   // Prepare to fill output forms with request data
   Tab = CreateObject("Table" ) ;
   Tab. SourceTable("layout");
   Tab. OutputSection("Header");
   State( "Filling the output table...") ;
   Tab. Options(0, 0, Tab.TableHeight(), 0);

   Here we check the possibility of executing the request and, if everything is in order, we create a spreadsheet document based on the layout and display the section Heading.

   Bye Request. Group() = 1 Loop
   // Filling the request fields
   Submittor = Abbreviated LP(Request. Submittor) + ", " + Abbreviated LP(Request. Legal Address) + ", passport " + Request. DocumentSeries + " " + Request. DocumentNumber + "issued" + Request. DocumentIssued by;
   Tab. OutputSection("Data");
   EndCycle ;
   // Output the completed form
   Tab. ViewOnly(1) ;
   Tab. Show("Report" , "" ) ;
   End of Procedure

   Now, in a loop, we traverse all groupings (and if there were no groupings, we would not be able to traverse the query result) and display the section Data. Remember how the expressions in the layout cells had to match the variables in the module? This is where it works. When displayed, sections of expressions are automatically replaced with the values ​​of the same variables. All data on the layout was obtained from the request, except for the sender data. It was collected from several query result fields.

That's it, the report is ready.

Accountable persons are employees of the organization who received cash in advance Money for upcoming administrative, business and travel expenses. At the same time, accountable persons must have labor relations with the organization regulated by the Labor Code of the Russian Federation.

In “1C: Accounting”, accounting of settlements with accountable persons is kept on balance sheet account 71 “Settlements with accountable persons” broken down by subaccounts:

• 71.1 “Settlements with accountable persons in rubles”;
• 71.11 "Settlements with accountable persons in foreign currency."

To reflect in the accounting of transactions for the issuance of cash from the cash register in rubles for reporting or compensation for overexpenditure in a standard configuration, a document is used "Consumable cash order" . The return of unused funds received by an employee on account for business needs or during a business trip is made using a document "Cash receipt order". Description of working with documents "Cash receipt order" And "Account cash warrant" given in section "Accounting for cash transactions".

Advance report

The document is intended for entering an expense report into the information base in a standard configuration "Advance report". The document generates accounting entries and has a printed form of the established form.

Document "Advance report" has a form that can be filled out on two tabs.

On the first tab "Front side" indicates the information that is reflected on the front side of the advance report. On the second tab "Flip Side" the tabular part corresponding to the reverse side of the expense report is filled out.

First of all, on the first tab you need to set the type of advance report - "ruble" or "currency". Depending on this, the amounts of funds issued and the amount of expenses are indicated in rubles or in foreign currency. In this case, the currency in which the advance was issued is additionally requested.

Props "Employee" filled in by selection from the directory "Employees".

If an advance report on the expenditure of funds received is submitted, then the details "Name of advance" indicates the purposes for which the advance was issued.

On the bookmark "Front side" The amount of the advance payment and the number of supporting documents attached to the advance report are also indicated. If settlements with the employee on the previous advance report are not fully completed, then the amount of debt or overexpenditure on the previous advance report is indicated. It can be entered manually or using the button "Show". In the second case, the document will show the status of settlements with the employee according to the data accounting(balance on account 71 “Settlements with accountable persons”).

We learn to draw up expense reports using examples (1C: Accounting 8.3, edition 3.0)

In my observation, for novice accountants, preparing expense reports is a significant challenge at first.

Today we will look at the basics of this matter, as well as the most popular cases from life. We will perform all experiments in 1C: Accounting 8.3 (edition 3.0).

So, let's begin

It’s not for me to tell you that 71 accounts are responsible for settlements with accountable persons in the accounting department:

Issue assets is reflected to the employee on the debit of this account, and write-off - on the credit.

Well, for example, they gave out 5000 against a report from the cash register:

Why did I say assets? This is because we can give the employee:

• Cash (from the cash register through cash register)
• Non-cash funds (transfer from the organization's current account to the employee's card account)
• Financial documents (for example, plane tickets for a business trip)

Let's look at each of the examples listed above.

Cash withdrawal from the cash register

To issue an advance from the cash register, we issue a cash receipt order (in the top three, this is the “Cash Withdrawal” document):

In the type of operation we indicate “Issuance to an accountable person”:

The wiring turned out like this:

Issuance of non-cash funds

In this case, the funds are transferred to the employee’s card account (the account to which the bank card, with which the employee can withdraw this money).

In the troika, this operation is formalized by the usual document “Write-off from the current account”:

Also, do not forget to indicate in the form of the “Transfer to an accountable person” operation:

The wiring turned out like this:

Issuance of monetary documents

A monetary document can be, for example, a plane ticket that an organization purchased for an employee who is going on a business trip.

After purchase, this ticket is accounted for as the debit of account 50.03:

When issuing this ticket to an employee for reporting (before a business trip), the accounting department draws up a document “Issue monetary documents":

And on the “Cash Documents” tab this very ticket is indicated:

The posting turned out like this (the ticket was written off from account 50.03):

I will specifically mention:

• We have the right to issue reports only to employees of the organization - persons with whom we have concluded an employment or civil law contract.
• The list of such persons is approved by a separate order of the head.
• The same order stipulates maximum term, through which the employee must report to the accounting department; if an employee goes on a business trip, this period is automatically extended until his return.

Employee reports

But assets are given to an employee for a reason, but to fulfill a certain official assignment. Therefore, the moment comes when the employee must report to the accounting department in form AO-1.

This is a printed form that indicates:

• everything that we gave to the employee for reporting
• everything he spent this money on (or didn’t spend it, or maybe there was an overspending)
• Supporting documents (checks, invoices, acts, tickets...) are attached to this form.

Here is an example of the AO-1 form:

This report (AO-1) is compiled by the employee together with the accounting department and approved by the manager. At the very bottom, the number of documents and sheets on which they are attached to the report is indicated (checks are usually pasted in whole packs onto A4 sheets).

So, in order to print such a report (AO-1), write off debt on 71 accounts from an employee, and also accept expenses in the top three, there is the document “Advance report”:

Let's briefly go through his bookmarks:

Examples of advance reports from life

Fill out the "Advances" tab:

It must be said that this tab is not displayed in any way in document postings, but is only available for the AO-1 printed form.

Fill out the “Products” tab (we bought a bunch of everything and put it on ten):

Here are the postings for this bookmark:

We fill out the “Payment” tab (we pay off the debt to suppliers, or pay an advance):

Here are the wiring:

Examples of filling out the "Other" tab.

Payment for communication services:

Payment for newspaper advertisements:

Write-off of daily allowance and debt for travel tickets:

Payment for some services (immediately charged to 26):

By the way, on the “Products” and “Other” tabs there is a checkbox “SF”, if you check it, then the received invoice will be entered on this line.

A business trip is not only a work moment, but also a small journey. Going on a trip without money is a bad idea. Let's figure out how to quickly and correctly draw up an advance report (travel allowances), how to report on time so that the accountant does not withhold this amount from your salary later. In the first part of the article we will talk about the legal nuances of the issue, in the second we will clearly tell and show how this is formalized in the program.

Why do you need an advance report?

An advance report is required for the employee to confirm expenses during a business trip, with a further detailed report. The accountable person is given a certain amount for future travel expenses: to pay for housing, buy food, pay for work or services related to the purpose of the business trip, as well as for other business and operational purposes.

The list of persons to whom such amounts will be issued, terms (days when the employee will be on a business trip), purposes (why the employee went on a trip), as well as the procedure for issuing cash in the organization are approved in accounting policy, either in a regulation or a separate order.

If a business traveler takes with him material values and there is no agreement on financial liability concluded with him, issue a one-time power of attorney for the transfer of valuables.

Deadlines for the advance report, confirmation of expenses and daily allowance

The terms for which such advances are issued are approved by the relevant order (the terms are not limited by law). The basis for the issuance of funds is a travel certificate (there is no longer a need for seconded employees to issue either an official assignment or a certificate) or an order from the manager to send the employee on a business trip.

The employee reports on the money spent and confirms the expenses with checks no later than three working days from the end of the advance payment period or after returning from a business trip. The employee submits an advance report to the accounting department confirming expenses for final payment. The advance report form is drawn up in a single copy.

The amount of daily allowance is determined in the accounting policy, in the order of the organization. Whatever amount of daily allowance you choose is what you accept as an expense from the point of view of income tax calculations. Minimum and maximum size The law does not establish daily allowances. Standards have been established within which daily allowances are not subject to personal income tax and contributions: 700 rubles in Russia, 2,500 abroad.

We fill out an advance report in “1C: Accounting 3.0”

Open the “Bank and Cash Office” section → the “Cash Office” group of documents and create an advance report. We set the date of the document and select an accountable person. The advance report is drawn up in the currency in which the funds were issued to the employee. The report currency is changed in the “VAT” window, in the amount - “Edit price and currency”. By default, the report is generated in rubles. The document has four tabs.

Advances tab

Here are all the documents with the help of which advances were issued to our employee: issuance of monetary documents, issuance of cash, debit from the current account.

Total advances received amounted to 26,000 rubles.

Products tab

We reflect the documents that the employee gives us. We enter documents in the “Goods” tab: checks, invoices, invoices for purchased material assets. We receive materials, fasteners and packaging to the warehouse: type of consumption document - Invoice No. 35 dated November 1, 2017. The supplier's invoice has been presented, we fill in the details, the accounting invoices have been filled out automatically according to the “Nomenclature” directory.

Payment tab. We will reflect the repayment of our debt to the counterparty.

Other Tab: we reflect daily allowances, expenses for purchasing tickets, entertainment expenses. Pay attention to the “Representation expenses” subconto: unlike “Travel expenses”, at the end of the month for the “Representative expenses” subconto 1C normalizes our expenses for the purpose of calculating income tax, so it is important to correctly fill out the subconto on the expense account.

They brought everything in, in total the employee spent 25,965, leaving a balance of 35 rubles. We post the document, at the time of posting, incoming invoices are created, and the document makes all the necessary postings. Let’s see by clicking on the “DtKt” button: all indicators are filled in. We print out the report (AO-1) and have it signed accountable person and file the document.

Unspent balance

There is an unspent balance of 35 rubles; the employee must report within three working days and deposit 35 rubles into the cash register. The easiest way to do this is from the expense report: “Create based on” → “Cash receipt”. The document is filled out automatically; we only specify the date of the document and the cash flow item: select “Other receipts from current operations.”

So, we looked at the procedure for filling out an advance report in 1C: Accounting 3.0. If you have any questions about filling out an advance report in 1C, we will advise you free of charge and within 15 minutes. Order a consultation.

Reflection of settlement transactions with accountable persons requires reference to the Employees directory.

To prepare a report for spent accountable funds, a standard configuration document, Advance Report, is used. To generate it, a document screen form is filled in, which can be accessed through the menu in ways similar to those for cash orders:

 Journals → Advance reports by entering a new document;

 Documents → Advance report;

 Operations → Document journals → Advance reports

 Journals → General journal → Insert → Advance report.

The screen form of the expense report, like the paper equivalent, consists of two bookmark sides: “Front side”, “Back side”. In the window that opens, fill out the form details in accordance with the content of the transaction being completed. When filling out the tabular part of the “Reverse Side”, each type of expense is indicated in new line tables.

To generate a printed form of the expense report, click the Print screen button.

Accounting entries are generated automatically when conducting an advance report.

To obtain summary and detailed information about the status of settlements with accountable persons on account 71, standard reports are used: Account balance sheet, Account card, Subconto card.

33.Accounting for banking transactions in the 1s 7.7 system

To reflect cash flows, directories such as Bank Accounts, Cash Flows are used, which are assigned as a subconto to accounts 51 “Currency Accounts” and 52 “Currency Accounts”. Therefore, before starting work, you should familiarize yourself with the analytics for these accounts.

Standard program configuration documents allow you to prepare payment documents for submission to the bank and enter information about completed transactions on current and foreign currency accounts. Work with payment documents (announcement for cash deposit, payment order, payment request, payment request-order, check register order and others) in the program is carried out in the Payment Documents journal, which is opened through the menu in one of the following ways:

 Operations → Document journals → Payment documents by entering a new document;

 Journals → Payment documents by entering a new document;

 Documents → Payment order or Payment documents;

 Journals → General journal → Insert → Payment request (Payment order, Payment request-order).

To issue a payment order, there is a screen form for the document "Payment order". The recipient's bank details are stored in the Counter-agents directory on the "Current Accounts" tab. If the necessary information is not in the directory, then the data is entered into it directly in the process of issuing a payment order.

After filling out and viewing the generated payment document, click the Write and OK screen button.

Transactions on the movement of funds on a current account are summarized in a standard configuration in the form of an Statement document, on the basis of which accounting entries in the accounts are generated. Opening a screen form and entering a new document can be done through the menu in one of the following ways:

 Operations → Document journals → Bank by entering a new document;

 Journals → Bank by entering a new document;

 Documents → Extract;

 Journals → General Journal → Insert → Extract.

In the screen form of the new document “Extract”, fill out the dialog boxes according to the conditions of the task.

The choice of statement type (ruble or foreign currency) determines the bank account, the statement from which is entered into the information base. The tabular part reflects account transactions according to the statement. When filling out the details of the extract, their values ​​are selected from the corresponding directories. For example, the nature of the payment is determined by selecting a subaccount from the Cash Flow directory.

The Statement document provides modes for automated processing of a bank statement, the selection of which is carried out by pressing the screen buttons Receipt by documents or Selection by payments. documents. For example, if the Statement reflects the debiting of funds from the account in accordance with the Payment Order, then to select suitable payment documents, click the Selection by Payments screen button. documents and make your selection. When funds from buyers are received on the basis of settlement documents issued to him and reflected in the information base, it is more convenient to fill out a line in the tabular part of the Statement document using the Receipt by Documents screen button.

To register the Statement in the information base and generate accounting entries, the document should be saved using the Write and (or) OK buttons.

In general, when maintaining a document, an Statement is generated for each line of the statement. accounting entry by debit (when credited) or credit (when written off) of account 51 (52) in correspondence with the account specified for this operation. An exception is receiving cash from an account or depositing cash into an account. For such transactions, in order to avoid duplication, postings will not be generated. In accordance with the accounting methodology adopted in the 1C: Enterprise program, they are formed when posting cash documents.

You can view accounting records generated based on the extract data in the Transaction Journal (Journals → Transaction Journal).

The statement is also used to reflect transactions on the organization's foreign currency accounts. To do this, select the appropriate currency account in the document.

To obtain summary and detailed information about the flow of funds in bank accounts, standard reports are used: Account balance sheet, Account analysis, Account card.