Accounting info. Accounting info Uploading a bank statement in 1s 8.3

A bank statement in 1C 8.3 Accounting is necessary to reflect the write-off and receipt of funds by bank transfer. It reflects information about the status of bank accounts at the current moment. Based on accounting statements, transactions on personal accounts are carried out.

Typically statements are generated daily. First, all cash receipts and debit confirmations are downloaded from the bank. Next, current payment orders are generated, which are transferred to the bank at the end of the working day.

A payment order is a document that instructs its bank to transfer a certain amount of its funds to the account of some recipient. This document does not have accounting entries.

In 1C: Accounting 3.0, payment orders are usually created on the basis of other documents, but they can also be created separately. Creation can be done from the list form of this document. To do this, in the “Bank and cash desk” section, select “Payment orders”.

In this example, we will consider creating a payment order based on the “Receipt of goods and services” document. To do this, open the already generated document you need and select the appropriate item in the “Create based on” menu.

The created document will be filled in automatically. If this does not happen, enter the missing data manually. Be sure to indicate the details of the recipient, the payer, the amount of the payment, its purpose and the VAT rate.

Uploading payment slips from 1C to the client bank

Most often, organizations upload payment orders to the bank at the end of the working day. This happens in order not to upload every document, but to upload all those accumulated during the day at once.

Let's look at how this is done in 1C: Accounting 3.0. Go to the form for the list of payment orders (“Bank and cash desk” - “Payment orders”). Click on the “Send to Bank” button.

A processing form will open in front of you, in the header of which you need to indicate the organization or account and the unloading period. At the bottom of the form, select the file into which the data will be uploaded. It will be created and filled in automatically. Check the boxes for the required payment orders and click on the “Upload” button.

To ensure the security of data exchange with the bank, a corresponding window will be displayed. Which will inform you that the file will be deleted after it is closed.

1C will most likely offer you to connect to the DirectBank service. Let us explain a little what this is. 1C:DirectBank allows you to transmit and receive data from the bank directly through 1C. This method allows you to avoid uploading documents to intermediate files, installing and launching additional programs.

To learn how to issue a payment order and debit a current account manually, watch the video:

How to unload a bank in 1C 8.3 and distribute it

Loading a bank statement into 1C is carried out using the same processing as uploading payment orders. Open the “Download Bank Statement” tab. Next, select the desired organization and the data file (which you downloaded from the client bank). After that, click on the “Download” button. All data will go from the file to 1C.

You can see how to manually reflect receipts from a buyer in 1C in this video:

On a note: If the recommendations below are not clear to you, and you need to configure it, then I recommend contacting us - Smart1C.ru. We will quickly configure the bank client for any 1C configuration.

All settings for exchange with a bank in the 1C: Accounting 8 program are placed on a single form. In order to set up the exchange of data on a bank account with the Client-Bank program, in the 1C: Accounting 8 program (rev. 3.0) perform the following steps:

For your information- for individual full-fledged work on the trading market, I recommend using the free Forex program. The program implements charts and contains economic market reviews necessary for analysis and decision-making.

In the program “1C: Accounting 8”, to reflect the payment received, the document “Receipt to the current account” with the transaction type “Payment from the buyer” is used, and to reflect the payment, the document “Write-off from the current account” is used. All these documents can be viewed by clicking on the menu tab - “Bank and cash desk” - “Bank statements”.

At this point, the client-bank settings from the Accounting 3.0 side are completed. All that remains is to work in it correctly, performing the exchange - loading/unloading.

The principle of working with a client bank comes down to the following actions:

1. Open the processing “Exchange with the bank” - “Bank and cash desk” - “Bank statements” - the “More” button - “Exchange with the bank”;
2. When you receive payment from the supplier, you export the file from the client bank to 1C - “Exchange with bank” - “Download bank statement” - “Download” button, the “Receipt to current account” document automatically appears;
3. If you need to pay a supplier, you create a new counterparty in the “Counterparties” directory, enter their “Bank Accounts” data, then in the program create a new document “Write-off from the current account” with the transaction type “Payment to the supplier”, post it, export this document from 1C programs - “Exchange with the bank” - “Send to the bank” - “Unload” and import into the Client Bank. Thus, you will have a 2-way exchange: 1C programs and Client-Bank.

Video - Client bank in 1C 8.3 setting up, uploading and downloading statements

Thanks to the progress and development of technology, the accountant no longer needs to manually post the final bank statement in the program. Technologically, the capabilities of Accounting 3.0 make it possible to automatically download statements from a client bank into the program.

Data from the bank is accepted in two stages. At the first stage, the statement is received in the bank program and compiled into a file. At the second stage, the extract is loaded into the 1C Accounting program.

For example, we will look at step-by-step instructions for uploading an already generated bank statement from the iBank program to the 1C Accounting 8.3 program.

STEP 1: Open the iBank program: on the main panel in the settings, select the “General” tab

STEP 2: In the window that opens, select the “Export” tab, use the mouse to open the window and begin the settings. In section 1C, put a checkmark (we check that there are no checkmarks anywhere else), and next to it we write the path to the file for saving the extract with the txt extension. At the bottom of the window, click the “Save” button

Fig.2

STEP 3: Now you need to select statements for the required date (if statements for a long period are loaded, general selection is possible using the key combination Ctrl + A). On the main panel, next to the Out button, select the down arrow and from the list that opens, select the “Export to 1C...” function.

Fig.3

The statements were generated into a file (the path to which we specified in step 2)

STEP 4: Before loading the statement into the program for the first time, it is strongly recommended to make a backup copy of the program! And you also need to check the list of counterparties in the database. Since the statement from the client bank is pulled into the database according to the TIN. If the directory contains counterparties with the same TIN, an error will occur when uploading the statement, since the program will not know who to link the statement to.

STEP 5: In the 1C program, on the main panel, select the “Bank and Cash Office” section, on the left side go to the “Bank Statements” item.

Fig.4

STEP 6: Double-click the mouse to open the “Bank Statements” journal on the panel at the top and click the Download button.

Fig.5

STEP 7: A window for contacting the bank opens on the screen. Select the "Upload to 1C: Accounting" tab and fill in all the necessary data: the path to the file (the one specified in step 2), and select a bank account.

rice. 6.

At the bottom of the window, click the download button.

The statements are loaded into the program. Check the download report by clicking the "Download Report" button at the bottom.

We regularly have to explain to accountants how to generate payment orders in a client bank, and also enter them into 1C programs again. To avoid double tedious work, it is enough to set up a simple transfer - loading bank statements into the program. The complexity of this operation is small for any accountant, and he is able to cope with it on his own and figure it out.

In a programme 1C:BP 8, edition 3.0, open the section Bank and cash desk and choose Bank statements.

In the window that opens, click the button Download and fill in the details of our Organizations and her Bank account, then press the button Settings. If after filling in the details Organizations the program displays a message,

then let's press Open settings.

Here we will select the program name from the drop-down list and specify the file to download.

To generate the required file, you need to go to your banking program, find a service for uploading data to 1C and create the necessary file.

Due to the huge diversity of bank clients, it is not possible to describe this to everyone. As a rule, you need to find the “Data Export” menu item and select export to 1C there. You can get more precise instructions by consulting your bank’s technical support or on the bank’s website.

In any case, when uploading a file, you will need to indicate the folder into which the file will be uploaded (remember it). In the future, in 1C you will need to enter the path to the folder in the “Upload file to 1C: Accounting” field.

The name of the file itself may differ from (kl_to_1c.txt). The “Upload file” field is filled in if you plan to initially enter outgoing payments in 1C, and then upload them to the client bank through this processing.

I also recommend unchecking the “Automatically run after downloading” checkbox. When the checkbox is enabled, documents are processed immediately, and you may miss something important. I advise you to go to each of them and conduct them yourself.

If you have done everything according to the instructions, then the settings have been made and the data file has already been downloaded from the client bank, then click the “Update from statement” button. Enjoy viewing the list of payment orders, focus on the “Type of transaction” column, then make the necessary corrections, if necessary, and click the “Download” button.

All! You can open bank statements in 1C and check/post downloaded documents.

Many accountants have to do double work - generate payment orders in the client bank, and then enter them again into 1C. A lot of valuable working time is spent on these operations only because when installing 1C, downloading an extract from the client bank was not configured. Making this setup is not at all difficult and I hope that my article will help you deal with this issue and save time.

We will look at the example of the 1C program: Enterprise Accounting 8, edition 3.0.

Go to the "Bank and Cash" tab and select the "Bank Statements" item.

In the window that opens, click the "Download" button, select the organization and bank account (data for each account is downloaded separately) and click the "Settings" button at the bottom of the screen. If, after selecting an organization, the program immediately displayed a message,

Then click "Open settings".

Select the name of the program (client bank) from the list. Then you need to specify the download file. What it is? This is a file that contains all the information about the cash flow in the account. In order to create it, you need to go to the client bank and find the unloading point in 1C. Unfortunately, I cannot describe how to do this, because... There are a lot of bank clients and they are all different; as a rule, you need to look for the “Data Export” menu item and select export to 1C (you can consult your bank’s technical support on this issue). When uploading a file, you will need to specify the folder in which it will be located. And then in 1C, enter the path to this folder in the “Upload file to 1C: Accounting” field.

The "Upload file" field is used if outgoing payments are made in 1C and then uploaded to the client bank. If you make all payments directly to the client bank, then this field does not need to be changed.

I would also advise checking the “Automatically run after downloading” checkbox. In my opinion, it is more convenient when documents are posted immediately, otherwise you will have to go into each of them and post them. And if the checkboxes are checked, you will need to manually review only those documents in which any details have not been filled in.

After the settings are made and the data file is downloaded from the client bank, click the “Update from statement” button. We look through the list of payment orders, especially carefully check the “Type of transaction” column, make corrections if necessary, and click the “Download” button. Now you can open a bank statement in 1C and view the downloaded documents.