Sure, I can tell you how to upload a bank statement from Avangard Bank to 1C. This process usually involves two main steps:
Exporting the bank statement from Avangard Bank’s online banking system. Importing the statement into 1C:Enterprise (specifically 1C:Accounting 3.0, as it’s the most common version).
Let’s break down each step.
Step 1: Exporting the Bank Statement from Avangard Bank Online Banking
The exact steps might vary slightly depending on the specific version of Avangard Bank’s online banking system or mobile app, but the general procedure is as follows:
Log in to your Avangard Bank online banking account (Internet Bank). Navigate to the "Счета" (Accounts) or "Выписки" (Statements) section. Select the Account for which you want to export the statement. Specify the Period for the statement (e. g., "за сегодня" — for today, "за неделю" — for the week, or a custom date range). Look for an "Экспорт" (Export) or "Выгрузить" (Download) button/link. Choose the Export format. For 1C, the most common and recommended format is "1C:Предприятие" (1C:Enterprise) or "TXT (Для 1С)". This format is specifically designed for direct import into 1C and usually has the extension. txt or. csv with a specific structure. If this exact option isn’t available, look for DBF, TXT, or CSV and ensure it can be customized to match 1C’s import requirements (though the "1C:Предприятие" option is usually the best). Save the file to your computer in an easily accessible location (e. g., your Desktop or a dedicated "Bank Statements" folder).
Important Notes for Avangard Bank:
- Avangard Bank is generally known for having good integration with 1C. You should easily find the "1C:Предприятие" export format. Make sure the period you select in the bank is the same period you intend to load into 1C to avoid gaps or duplicates.
Step 2: Importing the Statement into 1C:Бухгалтерия Предприятия 3.0 (1C:Accounting 3.0)
Once you have the. txt (or similar) file from Avangard Bank, you can import it into 1C.
Open 1C:Бухгалтерия предприятия 3.0. Navigate to the "Банк И Касса" (Bank and Cash) section. Select "Банковские Выписки" (Bank statements). In the "Банковские выписки" window, click the "Загрузить" (Upload/Load) button (it usually looks like an arrow pointing inwards or a folder icon). This will open the "Обмен с банком" (Bank Exchange) window. In the "Обмен с банком" window:
- "Путь К Файлу Выгрузки" (Path to export file): Click the folder icon (…) to browse and select the. txt file you saved from Avangard Bank. "Путь К Файлу Загрузки" (Path to import file): This field is usually for sending payment orders From 1C To the bank. You typically don’t need to specify it for importing statements. "Банковский Счет" (Bank Account): Select the corresponding bank account in 1C for which you are importing the statement. Ensure it matches the account from which you exported the statement from Avangard Bank. "Организация" (Organization): Select your organization if you have multiple organizations in 1C.
Click the "Загрузить" (Load) button in the "Обмен с банком" window. 1C will read the file and present a preview of the transactions it found. Carefully Review the transactions to ensure they are correct and match your expectations.
- 1C will try to automatically identify the counterparty and the correct accounting accounts (e. g., 60 for suppliers, 62 for customers, 76 for other counterparties, 91 for other income/expenses). Pay special attention to transactions where 1C could not automatically determine the counterparty or the account (they might be highlighted or marked with a warning). You will need to Manually correct these entries. You can usually double-click on a transaction line to edit its details.
Once you are satisfied with the preview and have made any necessary corrections, click the "Загрузить" (Load) button at the bottom of the preview window. This will create the actual "Поступление на расчетный счет" (Cash Inflow) and "Списание с расчетного счета" (Cash Outflow) documents in 1C. After successful loading, the new bank entries will appear in your "Банковские выписки" list. It’s good practice to Review the created documents (double-click on them) to ensure correct posting and accounting.
Troubleshooting Tips:
- File Format Errors: If 1C gives an error about the file format, double-check that you selected the "1C:Предприятие" or "TXT (для 1С)" format during export from Avangard Bank. If not available, you might need to adjust the export settings in the bank’s system or contact their support. Missing Transactions/Duplicates: Ensure the date range in the bank statement export matches what you intend to load. If you accidentally load the same period twice, you might get duplicates. 1C usually has mechanisms to prevent this, but it’s good to be cautious. Automatic Matching Issues: 1C matches transactions based on TIN (ИНН), name, and payment purpose. If any of these are inconsistent, manual correction will be needed. Consider refining your counterparty data in 1C. Insufficient Rights: Make sure your 1C user account has the necessary rights to perform bank operations.
Following these steps should allow you to successfully upload your bank statement from Avangard Bank into 1C:Бухгалтерия предприятия.
