Interaction with systems such as "bank client". Interaction with systems such as "bank client" Client bank in 1C 8.2 accounting

16.05.2024

Thanks to the progress and development of technology, the accountant no longer needs to manually post the final bank statement in the program. Technologically, Accounting 3.0 makes 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 extract 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.

Instructions

Launch the 1C: Enterprise program. Open the “Bank” section and select the menu item “1C: Enterprise – Bank Client”. If you have not configured sharing settings yet, you will be prompted to do so. Click Yes.

Start setup. In the drop-down menu in the “Program Name” section, select a certified application that matches what your servicing bank uses. For example, many credit institutions use the iBank 2 system.

Next, install the download and upload files for data exchange with the Client Bank. Be sure to check that the links are to different documents. Set the type of documents for data exchange and the encoding that matches the operating system of your personal computer.

Go to the "Download" section. Use the checkbox to mark the types of documents that you plan to work with when downloading a bank statement. Opposite them, mark the cash flow items. A group for new counterparties is selected below. Check that the changes you made are correct and click OK.

Log in to the Client-Bank system. Open the “ ” menu and select the “General” - “Data Import” section. Specify the format as 1C. From the Method drop-down menu, select Sync. Set the directory for data exchange, which must match the one specified in the 1C program.

Carry out a similar operation with the “Data Export” section. Check the entered data and click “Save”. Thus, the setup of data exchange between the Client-Bank system and the 1C: Enterprise application will be completed. When you perform any operation in one of these software, you can check that the synchronization is correct and make corrections if necessary.

Video on the topic

note

Open the “1C:Enterprise – Bank Client” item in the “Bank” menu: Since we have not yet configured the exchange parameters for our current account, the program will display the following window: Answer “Yes.” In the next window that opens, in the “Program name” field, from the drop-down list of certified programs, you must select the system that our bank uses.

Helpful advice

This is a system with which you can upload payments into the bank-client system and send them directly to the bank. Then the payment slips do not need to be entered directly into a separate bank-client program for sending to the bank. To set up interaction with the client-bank in 1C, you need to go to the “Bank” - “Bank Statements” menu. In the journal of bank statements that opens, click the “Download” button. Next, the client-bank form will open.

Sources:

how to work in a client bank

The company makes all payments in non-cash form, transferring cash accounts from one current account to another. Based on these transactions, the bank provides an extract within the established time frame, which acts as a primary document for accounting. Many accountants encounter difficulties associated with uploading statements into the 1C: Enterprise program.

Instructions

Receive a bank statement for your current account. Study the information provided and divide all cash flows into incoming and outgoing cash flows. Collect primary documentation (invoices, acts, contracts, payment orders, etc.) that confirms the completion of the financial transactions indicated in the statement.

Before setting up the exchange, let's answer the question: “Where is the exchange service with the bank in 1C?”

And, as it turns out, everything is not so simple here.

As a rule, they point us to the Bank Statements magazine, where the developers placed a magic button Download and they stop there. But we will go further and explore all possible ways to access this wonderful service.

Uploading from Client Bank to 1C 8.3 from the journal of bank statements

So, we have already named the first option - downloading bank statements is possible using the button Download from the magazine of the same name in 1C. This is a typical download option that developers offer for use. It will do the following:

But that is not all!

Uploading statements from Client Bank in 1C 8.3 from Exchange with bank processing in the Service group (Bank and cash desk section)

We can upload and download information on banking transactions from the processing itself Exchange with bankom. We can launch it traditionally through the Main Menu - All Functions, or by adding this processing to the active commands of the section Bank and Cashier.

You can do this from the action bar settings by adding the available command Exchange with bank to selected section commands:

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

But that's not all!

Uploading statements from Client Bank in 1C 8.3 from the Exchange with bank form in the bank statement journal

In the Bank Statements journal itself, it is possible to open a form Exchange with bankom by the action menu command MORE – Exchange with the bank.

This very command can be placed on the Bank Statements command panel. Since we, of course, want to be somewhat different from the monotonous coverage of this issue on the Internet, we will now consider this option.

We are sure that this will be useful to you in your future work.

Changing command properties Exchange with bank. From the action menu “More – Change form” of the Bank Statements journal, we will include the Exchange with Bank service in the journal command panel:

Processing Exchange with bank is available in the list of bank statements:

All options for calling the Exchange service with a bank:

Directly from the Exchange with bank form (section Bank and cash desk);
From Bank statements according to the book. Download;
From Bank statements using the action menu command More – Exchange with bank;
From the Main menu – All functions – Processing – Exchange with the bank.

Let's move on to the second part of the question - settings for Exchange with the bank.

How to set up downloading from the Client Bank in 1C 8.3 Accounting 3.0

Before you start setting up an exchange with a bank, enter the banking program and find the item in it Uploading to 1C. Copy the file name onto a piece of paper - this will be needed when setting up data exchange loading in 1C.

Now open the processing form Exchange with the Bank in 1C 8.3:

Displayed in form Exchange Bank organization and bank account through which we will perform operations for downloading statements and open the Settings form.

Exchange parameter settings are stored in a special information register Data exchange settings with the Bank Client: Ch. menu – All functions – Information registers:

After specifying the organization and bank account for which we will create an exchange setup, according to the book. Setting up, go to the form for setting up an exchange with the bank.

Settings for program name and download/upload files:

Serviced Banking check– is on by default.

The name of the program– the name of your banking program you are working with. You select the name of the program from the drop-down list provided by the developers.

For example, for SBERBANK this is a program AWS “Client” AS “Client-Sber”Bank" of Sberbank of Russia:

File download fromjar– this is the name and location of the file into which data will be downloaded from the Bank Client. Typically, the text file kl_to_1c.txt is used. But other options can be used.

The only condition: the name of the download file in 1C must match the name of the download file on the bank’s side. This is where the data recorded on a piece of paper from your banking program using the upload file in 1C will help. Please pay serious attention to this. This is the most common exchange setup mistake. If the path is specified incorrectly, the exchange will not work.

Another very important note: enter the file name without spaces, spaces, or unnecessary extensions. After entering, check that the file in the 1C window “Download file from Bank Client” and “Upload file in 1C” of your banking program completely match!

Check with your bank's technical support service about encoding of upload data. This can be either DOS or Windows. 1C supports working with both encodings.

Default substitution details

These settings are optional:

You can set the Cash Flow Item for substitution in the new documents Debiting from the current account and Receipt to the current account. But in fact, it rarely happens that the DDS article is the same for all occasions. Therefore, in order to avoid confusion and make mistakes, these fields are left blank. The data on them is filled in after the exchange is completed.

Groups for new contractors

Also with filling in the Group settings parameter for new counterparties. The accountant has the right to decide how he will control the counterparties in the database created by downloading bank statements in the event that 1C 8.3 did not find the necessary payers and recipients in.

Load/Unload Block

This block already works with the data received from the bank and, before generating new documents in 1C, asks you to decide on the loading and unloading actions:

We are now considering downloading statements from the Bank Client and here the user chooses whether it is necessary to automatically create new objects in the database and post new documents. But, probably, the checkboxes for posting documents of receipts to the current account and debits from the current account will be convenient.

Uploading from the Client's Bank to 1C 8.3 Accounting 3.0

Once you save the settings, you can start uploading documents.

After the cash flow data from the banking program has been uploaded to a file and received by the accountant, you can load it into 1C. During the loading process, the documents Receipts to the current account and Write-offs from the current account are created.

The sequence of actions of the accountant when downloading statements is as follows:

We indicate the bank account of the organization;
Choosing an organization;
Check the path to the download file;
We control the information in the data loading file;
Download bank statements;
We generate a report on downloaded statements:

If no mistakes were made in setting up the exchange with the bank, then the program will handle the download without any problems. Your task is to check the data before downloading:

What you need to pay attention to first:

When checking data before uploading, pay attention to the icon in the column next to the date:

An icon with a check mark means that the document is in the database and posted;
An icon without a checkmark indicates that the document is in the database, but has not been posted;
The icon with a “sun” signals that a new document will be created.

When loading data, a “not found” message appears:

By counterparty, if neither the bank account specified in the download file nor the TIN is found;
For the counterparty's account, if the account number is not found in the download file;
According to the contract, if the owner of the contract and the required type of contract are not found in the 1C database;
If there are several identical objects in the database, the first one from the list will be selected and a warning will be issued regarding the situation;
When re-uploading documents, the program analyzes the Amount and Payment Type data. If they change, the data is overwritten.

After downloading bank statements, you can print a report on the downloaded documents in 1C:

How to automatically monitor invoice payment, how this is affected by the status of invoice payment, that is, quickly report to the manager on paid and unpaid invoices, you can study the features of processing banking transactions in 1C 8.3 on our

It’s the 21st century and I’m surprised to learn that some accountants still enter bank statements into 1C: Accounting manually, although in all programs of the 1C family (starting with 7) this process is automated.

And if in 1C 7.7 there were still complaints about it, then the mechanism for loading bank statements for 1C: Accounting 8.3 (revision 3.0) truly deserves all praise.

I’ll tell you step by step how to download statements from your client bank (using the example of the iBank system as the most common now) into 1C: Accounting 8.3.

1. Launch the client bank. From the main menu, select "Settings" - "General".

2. In the settings that open, go to the "Export" tab. Check the box in section 1C and uncheck all other sections. As an exchange file in section 1C, enter any path to a file with the extension ".txt". Click the "Save" button.

3. Now get the statements for the required number, select them all (key combination Ctrl + A) and select the down arrow in the panel next to the Out button. From the list of commands that opens, select "Export to 1C...".

4. Half the battle is done! The statements were uploaded to the same file that we specified in the client bank settings.

Since you are downloading statements for the first time, this is a necessary precaution.

5. Now launch 1C and go to the “Bank and Cash Desk” section. And then select "Bank Statements" in the panel on the left.

6. In the statement log that opens, click the “More” button and select “Exchange with bank” from the drop-down list:

7. An exchange window with the bank has opened. Select the "Load from Bank" tab.
Specify the bank account and the file into which statements from the client bank were downloaded:

8. In the bottom panel, click the "Download" button. And all extracts from the file will be uploaded to 1C.

9. Done! All that remains is to view the "Load Report".

How to download statements from a client bank into 1C Accounting 8.3 (revision 3.0)

2016-12-07T18:26:50+00:00