Accounting info. Accounting info Enter bank statement into 1c
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:
- Open the processing “Exchange with the bank” - “Bank and cash desk” - “Bank statements” - the “More” button - “Exchange with the bank”;
- 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 document “Receipt to the current account” automatically appears;
- 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
Usually, working with bank statements is configured automatically through the client-bank system, but the ability to integrate client-bank and 1C is not always possible. In this case, work with the bank will have to be done manually. Let's look at how the necessary documents are generated.
Creating a payment order
In order to transfer money from an organization’s current account to pay suppliers, pay taxes and other fees, you need to create a payment order. On the “Bank and cash desk” tab, select the “Payment orders” item:
A list of payment orders opens. In the upper left part of the document, click the “Create” button, a form for a new payment order opens. The following fields are filled in:
- Transaction type – selected from the proposed drop-down list according to the type of payment being made;
- Recipient – the required counterparty is selected from the counterparty directory, the recipient’s account and the agreement are filled in automatically from the counterparty’s details;
- Amount of payment;
- VAT – by default it is set from the counterparty’s data;
- VAT amount is calculated automatically;
- Purpose of payment.
It is important to correctly indicate the type of operation, since depending on the selected operation, the document details will change.
For example, when choosing the type of transaction “Payment of tax”, you will need to fill out the “Type of obligation” field, you can change the BCC and OKTMO code (by default they are filled in with current data). The order for payment to the supplier looks like this:
After completing a completed order to pay the supplier, no transactions are generated in 1C; it is just an information document that records the need to generate a similar payment order in the client-bank system (remember, we are talking about manual work).
Another way to create a payment order manually is through the “Pay” button, which, like the “Create” button, is located above the list of payment orders. When you click, a list opens from which you can select the desired type of payment: “Accrued taxes and contributions” or “Goods and services”:
When you select one of the items, it will analyze the organization’s debt and generate a list of documents that require payment:
To create payment orders to several creditors at once, you can mark the required documents in the list and click the “Create payment orders” button.
New payments will appear in the list. They are in bold and not posted because they need to be verified. After checking the correctness of filling and the correctness of the amounts, the order is carried out. In this case, you also need to duplicate the order in the client-bank system.
As soon as the bank has confirmed that this payment has been transferred to the recipient, the movement of funds in the accounts must be reflected in 1C and debited from the organization’s current account.
You can debit your current account from the same payment order. In it you need to set the status to “Paid” and click on the hyperlink “Enter a debit document from the current account.”
The document “Write-off from the current account”, unlike a payment order, generates transactions in 1C.
You can see the transactions by clicking the “Show transactions” button:
Everything was filled out correctly: funds were transferred from the organization’s current account to the supplier’s current account, which is reflected by posting Dt60.01 - Kt51. In the list of payment orders, a check mark appears in the first column opposite paid documents:
Receiving payments from buyers
To reflect the receipt of funds to the organization’s current account, use the “Bank statements” item in the “Bank and cash desk” section:
When you select this item, a journal opens that reflects all receipts and debits from the current account:
To enter information about receipt, use the “Receipts” button. The document “Receipts to the current account” opens, in which the following fields are filled in:
-
The VAT rate, contract and movement item of the DS are filled in from the previously established values.
Type of transaction – in our case, “Payment from the buyer” is set;
Payer – the counterparty from whom the money came is selected from the directory;
After filling out all the data, the document is posted:
Once done, you can check the wiring:
Posting Dt51 - Kt62.02 shows that money has been received from the buyer to our account.
The list of bank statements shows current information on the current account status for the current day:
Information is provided on the amount at the beginning of the day, on receipts and write-offs for the day, and the balance at the end of the day.
If you need to clarify information for any other day, you can use the calendar to select the desired date:
A list will be generated for the selected day, which will also show all information about the account status.
Register of documents
To obtain summary information on transactions on a bank account, use the “Register of Documents” report; the button of the same name for creating it is located in the journal of bank statements. After clicking the button, a document is generated for printing:
An already completed document is created; all that remains is to post it after verification:
The counterparty's debt for this sale is extinguished, and the receipt automatically falls into the sales subordination structure:
Payment orders are issued in a similar manner based on purchases and receipts of services.
Checking the status of your current account
You can check the status of your current account both in the journal of bank statements and through the “Start Page” on the main page of 1C:
Also, to check the account, you can use the balance sheet for the account (51 accounts for ruble transactions, 52 for foreign currency transactions).
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:
How to generate an extract in the 1C 8.3 Accounting program?
In this article I will tell you how to use the functionality of bank statements and exchange with a bank client in 1C 8.3 Accounting 3.0:
- where in the program interface are bank documents located?
- how to create a new outgoing payment order
- how to upload payment slips for payment to a client bank
- how to download incoming payment orders and payment confirmations from a client bank
Working with the bank
The general scheme of work for a single day with statements in 1C is as follows:
- We download from the bank client into 1C: receipts for yesterday and confirmation of yesterday's outgoing payments (+ commissions)
- We create payment orders that need to be paid today
- We upload them to the client bank
And so every day or any other period.
In the interface, the journal of bank statements is located in the “Bank and Cash Office” section:
How to create a new outgoing payment order
A payment order is a document to be sent to the bank; it can be printed using a standard bank form. Entered on the basis of the Invoice, Receipt of goods and services and other documents. Be careful, the document does not make any accounting entries! The postings are made by the next document in the chain, 1C 8.3 - “Write-off from the current account.”
To create a new document, go to the “Payment orders” journal in the above section and click the “Create” button. A new document form will open.
The first thing you need to start with is choosing the type of operation. The choice of future analytics depends on this:
For example, select “Payment to supplier”. Among the required fields for this type of payment:
- Organization and organization account - details of our organization;
- Recipient, agreement and invoice - details of our counterparty-recipient;
- Amount, VAT rate, purpose of payment
After filling out all the fields, check that the details are correct.
Uploading payment orders from 1C to the client bank
The next stage is the transfer of data on new payments to the bank. Usually in organizations it looks like this: throughout the day, accountants create a lot of documents and at a certain time the responsible person uploads payments into the banking program. Uploading occurs through a special file - 1c_to_kl.txt.
To upload, go to the payment order journal and click the “Upload” button. A special processing will open in which you need to specify the Organization and its account. Then indicate the dates for which you need to upload and where to save the resulting file 1c_to_kl.txt:
Click upload, we get a file with approximately the following content:
It needs to be loaded into the client bank.
Loading client's bank statements into 1C
Almost any bank client supports uploading a file in the KL_TO_1C.txt format. It contains all the data on incoming and outgoing payments for the selected period. To download it, go to the “Bank Statements” journal and click the “Download” button.
In the processing that opens, select the organization, its account and the location of the file (which you downloaded from the client bank). Click "Update from statement":
We will see a list of documents 1C 8.3 “receipts to the current account” and “debits from the current account”: both incoming and outgoing (including for bank services). After checking, just click the “Download” button - the system will automatically generate the necessary documents according to the list with the necessary accounting entries.
- If the system does not find a counterparty in the 1C database using INN and KPP, it will create a new one. Be careful, there may be a counterparty in the database, but with different details.
- If you use cash flow items, be sure to fill them out in the list.
- If the created documents do not contain accounting accounts, fill them in the information register “Accounts for settlements with counterparties”. They can be set both for the counterparty or agreement, and for all documents.
Based on materials from: programmist1s.ru