How to download bank statements and upload payment orders. How to download bank statements and upload payment orders Uploading a file for 1c from BBR bank

Users of 1C programs can set up automatic exchange of data on settlement transactions with the organization’s bank. In 1C 8.3 Accounting 3.0, special processing serves these purposes Exchange with bank.

You can work with a Bank Client in 1C 8.3:

Directly from the Exchange with bank form (section Bank and cash desk);
From the Bank Statement Journal;
From the magazine.

Uploading from 1C: Exchange with bank forms to Bank Client

By default, Exchange with a bank is not included in the list of displayed commands in the Bank and cash desk section. Therefore, you must first configure the section’s action panel and add the Exchange with bank command to the Service group:

Team Exchange with bankom will appear in the Service group (Bank and cash department section):

Uploading from 1C: Journal of Bank Statements to Bank Client

According to the book MORE – Exchange with the bank From the log you can call the Exchange with bank command. According to the book MORE – Change form can be placed Exchange with bank immediately on the command panel of the Bank Statement journal:

The Exchange with bank command has appeared on the command panel of the Bank statements journal:

Uploading from 1C: Payment order journal to Bank Client

According to the book Upload we get to the exchange form with the bank:

Let us remind you that this article discusses setting up an exchange with a bank for uploading payment orders 1C 8.3 Accounting 3.0 TAXI.

How to set up uploading from 1C 8.3 to Bank Client

Payment documents are uploaded on the tab Unloading to banc:

In the upload form, indicate information about the organization, bank account and fill out the form for setting up an exchange with the bank according to the book. Setting:

We fill in the following data:

The name of the program– name of the banking system program into which the uploaded file is transferred. Selected from the list of possible options provided by the developers:

Upload fileto the bank– a file where information on selected payment cards will be recorded. In 1C, the text file 1c_to_kl.txt is used for uploading. But you can use other options. The only condition: the name of the upload file in 1C must match the name of the upload file on the bank’s side:

Encoding- DOS/Windows. The encoding must correspond to the encoding in the Bank Client setting. 1C supports exchange in both encodings:

Block Unloading

– Types of uploaded documents. By default, payment orders are selected.

– Checking the correctness of the document number.

ATTENTION! Setting up exchange parameters is done separately for each bank account and is saved in a special information register: Onconstruction of data exchange with Klientom bank(main menu – All functions – Information registers).

Information Register: Settings for data exchange with the Bank Client stores information for each organization:

How to upload a payment card from 1C 8.3 to the Bank Client

You can upload payment slips from 1C 8.3 to the Bank Client:

From the Exchange with bank form (Bank and cash desk section). If you place the processing in “Favorites”, it will be available from anywhere the user works.

From the list of Payment orders according to the book. Unload. When you press the button. Unload control is transferred to the exchange form with the bank.

The bookmark is intended for downloading data. Uploading data. To fill out the list of data for uploading, you must fill in the organization for which the data is being prepared, the bank account and the selection period based on the dates of the documents being uploaded.

If necessary, the user can open documents and make corrections to them by double-clicking on the line with the document.

Commands for working with uploaded documents

Team Update.

Updates the list of documents without closing the form after changes are made to the documents.

Teams Check all/Uncheck all.

With their help, you can check and uncheck the upload boxes for the entire list of selected documents.

Team Find.

Makes a selection based on selected document parameters: date, number, counterparty, amount, current account. Convenient for large lists of documents.

Teams Sort (Ascending/Descending).

Sorting functions are convenient when processing large volumes of documents. If you need to select certain amounts or counterparties. Sorting works on all list fields.

To work with the search for the necessary documents, place the cursor in the Contractors column and call the “Find” command for the counterparty.

Selection of payment bills when uploading from 1C 8.3 to the Bank Client

In the first column there is a checkbox that marks the document from the list for uploading to a file. The user can decide for himself which documents to submit to the bank now and which later, by setting and unchecking the upload flag for the document.

What to look for: manually enter the required data:

Book Find: selection starts based on the set condition. In the selection list that appears, click the button. Select all or selectively mark those positions that we need.

After selecting the required documents, the total amount for the selected documents is shown at the bottom of the tabular section:

Uploading selected payments from 1C 8.3 to the Bank Client

The sequence of actions when uploading selected documents to a file is as follows:

After execution steps 1-3 the program will generate a list of documents that the accountant works with using sorting and selection commands.

After preparing the list of documents for uploading, filling in the details is checked Upload file to bank (action 4). By default, the filling comes from the exchange settings.

Uploading documents to a file is done according to the book. Unload. If the upload is successful, a pop-up window appears at the bottom of the screen indicating that the data was successfully uploaded to the file. You can visually check the generated upload file by opening it using the hyperlink Uploaded file:

Report on uploaded payments from 1C 8.3 to the client bank

After the upload is completed, we generate a report for monitoring the uploaded documents:

On the website you can see our other free articles and materials on configurations:

In order not to manually enter bank statements into your enterprise software, you should ask how to load a bank into 1C 8.3. Simply put, this process can be automated for a long time; you just need to approach this task correctly. Entrust the setup of the 1C program to programmers and you will never return to this issue.

How to load jars in 1C 8.3?
If you follow the entire download process step by step, you will end up with everything you planned. You must have a good understanding of the system interface. The main action processes are divided into three groups:
uploading from the client bank to a file;
creating a backup copy;
loading from a file into the 1C database.

These are fundamental tasks on the way to loading the bank in 1C 8.3. The first process looks like this: menu “Settings” - “General”. In the new window, select “Export”.

Be sure to check the box next to 1C “File for exchange” and enter the correct path to the document there. Its extension should only be txt. Next, to load the client bank into 1C 8.3, we confirm our action by clicking on “Save”. In the next window, click on the “Out” button and select “Export to 1C...”. We can consider that we have successfully completed the first of three important processes.

Next, we are working on creating a backup copy for loading the bank into 1C 8.3. This step is your guarantee of safety. It is better to prevent yourself from possible troubles than to eliminate them later. After you have completed this stage, we move on to the very last and most important task - loading from a file into the 1C database.

To ultimately load the bank into 1C 8.3 successfully, follow the following chain of actions: section “Bank and cash desk”, item “Bank statements”. In the journal, click on “More”, go to “Exchange with the bank”. A tab called “Download from Bank” will appear in a new window, go into it and at the very bottom click on “Download”.

Automation details in 1C
The entire process of loading a bank statement into 1C 8.3 can be considered complete if you followed a clearly defined algorithm of actions. If you encounter difficulties at any stage, please contact technical support. Specialists will help you understand any current situation, especially if it concerns loading banks in 1C 8.3.

Every software user needs to have a good understanding of all system settings. 1C is a storehouse of functionality that you need to learn to use, and then the software will work for you. After the correct setup associated with loading the bank classifier into 1C 8.3, the system will become your indispensable assistant.

Using the classifier contained in some of the programs, you will always receive up-to-date data regarding the details of banking institutions. In order to load the bank classifier in 1C 8.3, you should go to the “All functions” menu, go to the “Directory” and select “Banks”. In the new window, click on the “Select” button, then on “Load classifier”. We put a tick next to the entry “from the agency’s website...”, and upon completion of work, we confirm all our actions by clicking on “Next”. That’s it, we can assume that you have completed loading bank classifiers into 1C 8.3.

Joint setup with the company "Setbi"
If you are looking for a worthy specialist in the field of implementation and automation of 1C software, then contact us. Many accountants try to independently configure the download of bank statements in 1C 8.3. For unprepared people, this takes a lot of time, and the result is not always satisfactory.

It’s better not to save money and trust the professionals. After all, after you have established the exchange of documentation between banks and loading bank statements into 1C 8.3 is successful, the work will proceed faster and more efficiently. And this is one of the main goals of any entrepreneur.

The Setby company will provide you with a full consultation over the phone, after which you will find out what needs to be done to ensure that the download from the bank to 1C 8.3 is successful. Our technical support is available 24 hours a day. Leave your contact numbers and we will contact you as soon as possible.

Payment orders, or payment slips, are downloaded from 1C 8.3 for further loading into the client bank. To correctly upload payment bills, you need to configure certain 1C 8.3 parameters. Read on to learn how to set up an exchange and how to upload payment cards from 1C 8.3 to the client bank.

Read in the article:

After you have created payment orders in 1s 8.3, you can upload them to the client-bank system for payment. The procedure for exchanging payments in 1C 8.3 consists of two stages:

uploading a text file from 1C 8.3
uploading this file to the client bank

To generate an upload file in 1C 8.3, you need to set up an exchange with the client-bank. Setting up the exchange is necessary not only for the correct upload of payment slips from 1C 8.3, but also for loading bank statements from the client bank into 1C 8.3. In this article we will tell you how to set up an exchange and how to upload payments from 1C 8.3 to the client bank in three steps.

How to download payments from BukhSoft

Step 1. Set up data exchange with the client bank in 1C 8.3

Go to the “Bank and cash desk” section (1) and click on the “Payment orders” link (2). A window will open with a list of previously created payments.

In the window that opens, in the “Organization” (3) field, select the organization (4) for which you want to set up an exchange. A window will open with a list of created payments for the selected organization.

Next, click on the “Send to bank” button (5). A window for exchanging data with the bank will open.

In the “Exchange with Bank” window, click the “Settings” button (6). The exchange settings window will open.

Step 2. Specify data exchange settings in 1C 8.3

In the “Exchange Settings with Bank Client” window, specify:

your bank account (1). Select the bank account for which you are setting up the exchange;
program name (2). Select from the list the bank client program that corresponds to your bank account, for example, “Client-Bank System” of CJSC “Bank “New Symbol””;
upload file to the bank (3). Here, click “Select” (4) and specify the name of the file and its location on the disk. When uploading payment invoices, this file will be used for exchange;
correctness of the document number (5). Check the box if you want the client bank to check payment slip numbers for repeatability.

After completing the settings, click the “Save and Close” button (6).

Step 3. Upload payments from 1C 8.3 to the client bank

Client bank - a program for remote work with your servicing bank. In such systems it is possible to download files with payment slips from 1C 8.3. To download a file from 1C 8.3, go to the “Bank and Cash Desk” section (1) and click on “Payment orders” (2). A list of payment orders that you created in 1C 8.3 will open.

In the window that opens, select your organization (3).

Now in the window you will see payments only for the selected organization. Next, click the “Send to Bank” button (4). The “Exchange with Bank” window will open.

In the window you see payment orders prepared for payment. They are in the Prepared state (5). Payments that will be downloaded are marked with ticks (6). You can uncheck payment orders if you do not want to pay for them. In the “Upload file to bank” window (7) you will see the path to the file that you specified in setting up the exchange with the client-bank. You can specify another file to upload. To do this, press the “…” button (8). To save the file with payments, click the “Upload” button (9). After this, the payment status will change to “Sent”. Your payments have been sent to the bank.

The file with payments is visible in the “Upload file to bank” field (7). Log in to your bank client and download this file to make a payment. You specified the location where this file is located in setting up the exchange with the bank (see step 2).

In the process of work, in each organization, there is interaction with other companies (organizations). Payments must be made for outstanding goods, works, services, taxes and other payments. Currently, this process occurs through the Client-Bank system. This program is installed by bank employees on the computer of a company employee to make payments and load payment orders into the program in which accounting is carried out. Let's look at how bank statements are loaded into 1C.

Uploading statements from the Client-Bank program

In order to download an extract from the Client-Bank program, you must:

Generate a statement for the required period;
Export it to a text file to transfer data.

Export occurs when you click on the “Export”, “Export” or something similar button; in different Client-Bank programs this button is called differently. The generated file is uploaded for export to the desired folder, along a predetermined path.

In front of the tabular part of the document in the right corner we find the “More” button, click on it, a window appears with a list of functions, select the “Exchange with bank” item in it.

The organization through which payment orders will be downloaded;
Organization bank account.

Click “Download” at the bottom of the document and after that, in the tabular part, all statements from the bank will be loaded into the “1C: Accounting” program. After this, we review the report on the uploaded file and proceed to processing payment orders.

You can set up automatic processing of payment documents upon receipt and debit. To do this you need to configure.

You can select the “Setup with Client-Bank” document:

By clicking the “Settings” button at the bottom of the “Exchange with the bank” document;

In the “Bank Statements” journal, select the “Set up exchange with the bank” item from the list when you click on the “More” button.

In the settings, fill in the fields:

We indicate the bank account from which statements will be downloaded;
The name of the program is selected from the list provided by the developers - this is the program you are working with. After this, the fields “Upload file from 1C Accounting” and “Download file from 1C Accounting” open. “Upload file from 1C Accounting” only if outgoing payment orders are generated in the 1C database and then uploaded to Client-Bank;

The condition that must be met is the name of the download file in 1C, it must match the name of the download file from the Client-Bank program.

At the bottom of the settings, two fields open, the left one shows upload data, and the right side shows download data.

In the “After loading automatically post” field, it is advisable to indicate two checkboxes on the positions “Receipt to the current account” and “Write off from the current account”, in this case payment orders will be automatically processed, which in the future only need to be double-checked without going into each of them.

After uploading payment orders, you should carefully check the “Type of transaction” and the created accounting entries, and make corrections if errors are found.

Uploading statements from a banking program into 1C is a very convenient procedure that significantly facilitates the work of the accounting department, significantly saving employees’ time.

To download payment orders from the 1C: Accounting 8 database, you need to open the “Bank and Cash Office” tab and select the “Payment orders” line in the “Bank” section. Click "Upload".

In the tab that opens, select your organization (No. 1) in the drop-down list, the bank account appears automatically. In field No. 2, indicate the date or time period when the payment order was created. Next, in the main field, check the boxes for those payment orders that you want to upload to the client bank.
Below (No. 3) select the location to save the upload file on your computer and its name.
Click "Upload" No. 4.

All that remains is to upload the statement to the client bank.

How to download statements from a client bank into 1C: Accounting 8

To download statements from the client bank, you need to go to the same “Bank and cash desk” tab, but select the “Bank statements” line.

In the tab that opens, click “Download”. A file selection window will open, select the one you need (the document must be saved in *.txt format). In a couple of seconds (sometimes minutes, if there is a lot of data), the list of statements will be replenished with new lines. Next you need to carry them out. To do this, select the required lines, click “All actions” and select “Perform”.