Site.pro
  • AI Website Builder
    • AI Website Builder
    • Prices
    • Website Import
    • Online Stores
    • Plugins
    • Collaboration
    • Templates
    • Languages
    • Affiliate Program
    • Examples
    • For Design Studios
    • Website Builder
    • For Domain Investors
    • We Build for You
  • Domains
  • Email
  • Learn
    • Website Builder Video Tutorials
    • Blog
    • FAQ
    • Growth Hacking
    • For Hostings
    • Domainity
    • For Education
  • Accounting Software
    • Knowledge Base
    • Sole Proprietor
    • Accounting Software
    • Modules
    • Integrations, API
    • Prices
    • Business Types
    • Invoice Recognition
    • Training
    • Affiliate Partners
    • Accounting companies (360)
    • Software integrators (48)
    • Teaching Institutions (68)
    • Useful Links
  • For Resellers
    • Prices
    • White Label
    • Revenue Share
    • Panels
    • How it Works
    • Mass Import
    • Our Partners
    • Reselling Examples
    • Marketing Materials
    • Documentation
    • Free Websites
  • AI Website Builder
    • AI Website BuilderCreate your website easily and for free with AI. AI is creating website for you in seconds
    • PricesSite.pro Prices: Templates 200+, Websites, Basic Builder Functions, Online Stores.
    • Website ImportTransfer your existing website from anywhere to Site.pro website builder.
    • Online StoresSell your goods or services anywhere on the website.
    • PluginsMany functions and plugins depending on geographical preferences.
    • CollaborationCollaborative Website Builder, Create a website with teammates in real-time in one space.
    • Templates
    • Languages
    • Affiliate Program
    • Examples
    • For Design Studios
    • Website Builder
    • For Domain Investors
    • We Build for You
  • Domains
  • Email
  • Learn
    • Website Builder Video TutorialsVideos for Beginners. Download video tutorials for free! New video tutorial.
    • BlogWebsite Builder Lifehacks: Shared Hosting tips from Hosting Market Leaders.
    • FAQUse this FAQ database to find information about working with Site.pro products quickly and easily.
    • Growth HackingBoost your sales. Strategy
    • For HostingsEducation. Generate more website builder sales.
    • DomainityDomainity: Domain quantity per 1000 people
    • For EducationFree Website Builder for Online and Offline Classrooms.
  • Accounting Software
    • Sole ProprietorAutomated invoicing, accounting of expenses and income, e-shop integrations.
    • Accounting SoftwareAccounting software designed for small and medium-sized companies
    • ModulesModules required for accounting of production, trade, service provision and other companies.
    • Integrations, APIPlugins for e-shops, synchronisation with trading portals, Integrations With Cash Registers and POS Systems, Other Integrations.
    • PricesSite.pro accounting software 30 days for free. Comparison of plans, import from other programs.
    • Knowledge Base
    • Business Types
    • Invoice Recognition
    • Training
    • Affiliate Partners
    • Accounting companies (360)
    • Software integrators (48)
    • Teaching Institutions (68)
    • Useful Links
  • For ResellersWhite Label
    • PricesStart reselling. Pay for live websites. Free Websites.
    • White LabelThe most popular white label tool is ideal for reselling
    • Revenue ShareWebsite Builder: Provide free website builder and earn 50% commissions.
    • PanelsOne product for all platforms. Download plugin for your panel.
    • How it WorksCloud or On-Premises. Recommendations for Builder Server.
    • Marketing MaterialsVideo. Mockups. Website Blocks. Marketing Materials.
    • Mass Import
    • Our Partners
    • Reselling Examples
    • Documentation
    • Free Websites
  • Register
    By registering, you accept our Terms of Service
  • Log in

    Log in

    New user? Create account
    Forgot password?
  • $
  • English
  • Registers (96)
    • Item cards (29)
      • Items (19)
      • Item attributes (7)
      • Item groups (2)
    • Warehouse (48)
      • Warehouses (3)
      • Operation types (25)
      • Doc. series (2)
      • VAT rates (9)
      • VAT classification (9)
    • Intrastat (10)
      • Intrastat item codes (2)
      • Intrastat delivery terms (2)
      • Intrastat transports (2)
      • Intrastat transactions (2)
    • Locations (1)
    • Banks (2)
    • Currencies (4)
    • Currency exchange rates (2)
  • Encyclopedia (15)
  • Account (134)
    • Dashboard (19)
    • Companies and users (31)
    • Employee account (17)
      • Payroll (1)
      • Requests (2)
      • Schedule (1)
      • Information (2)
      • File upload (8)
    • My data (24)
    • Affiliate program (4)
    • Invites (2)
    • Reminders (2)
    • Support (7)
    • Statistics (4)
    • Other information (19)
  • Settings (397)
    • Settings (65)
      • Users / employees (2)
      • Sending invoices by email (1)
      • Self-employed (7)
      • Approval of documents (1)
      • Additional sale attributes (1)
      • Additional item attributes (1)
      • Additional employee attributes (1)
      • SAF-T (sttings) (1)
      • Purchases (2)
      • Recognition of accounts (1)
      • System and logos (8)
      • Data exchange (4)
      • Bank (1)
      • Reports (3)
      • Declarations (9)
      • Accounting (11)
      • Stock-taking (1)
      • Sales (9)
      • Warehouse (1)
    • Integrations (319)
      • API (59)
        • API (47)
        • API #2 (10)
      • Platforms (200)
        • eBay (28)
        • Amazon (28)
        • Shopify (31)
        • Etsy (28)
        • Site.pro (23)
        • Varle.lt (19)
        • Verskis (21)
        • Pigu.lt (21)
      • Cash registers (25)
        • Raso cash registers (15)
        • Cash registers (6)
        • R-Keeper (2)
        • nSoft (1)
        • Paysera POS (1)
      • Paysera (2)
      • Automatic import of bank statements (via Neopay) (4)
      • Data exchange with Creditonline.eu (1)
      • MIP (5)
    • Data import (12)
  • Declaration (47)
    • Generate declarations (22)
    • Declaration signs (2)
    • i.VAZ (4)
    • i.SAF (10)
    • SAF-T (1)
    • GPAIS (6)
  • Salary (70)
    • Payroll (31)
    • Timesheets (7)
    • Work schedule (2)
    • Wage prints (14)
    • Registers (13)
      • Wage codes (Registers) (5)
      • Departments (Registers) (1)
      • Work schedule register (Register) (1)
      • Salary parameters (Registers) (6)
  • Documents (61)
    • Orders (31)
      • Orders (19)
      • Order attributes (9)
      • Daily allowance (2)
    • Insurance (1)
    • Agreements (2)
    • Emails registry (2)
    • Outgoing mail register (1)
    • Incoming / Outgoing document register (2)
    • Annual leave (17)
      • Accumulated holiday days (5)
      • Vacation balances (6)
      • Vacation balances (4)
    • Incapacity certificate (2)
    • Internal documents (2)
  • Assets (21)
    • Long-term assets (19)
      • Long-term assets (9)
      • LTA depreciation (2)
      • LTA inventory (1)
    • Low value assets (1)
    • General report (1)
  • Production (12)
    • Technological cards (3)
    • Production from technological cards (5)
    • Bundle / debundle (4)
  • Dashboard (company) (46)
  • Personnel (40)
    • Employees (28)
    • Requests (1)
    • CV (1)
    • Registers (8)
      • Job positions (2)
      • Employee groups (1)
      • Tax exempt income (2)
      • Request types (3)
  • Reports (54)
    • Inventory report (10)
    • General ledger reports (16)
    • Ind. activity report (8)
    • Sales-purchases (6)
    • Debt management (4)
    • Balances / PLN (5)
    • Other reports (4)
  • Cashier (19)
    • Cashier (17)
    • Money receiving receipts (1)
    • Registers (1)
  • Bank (61)
    • Bank (36)
    • Bank link with cor. account (2)
    • Import statements (16)
    • SEPA payments (5)
  • General ledger (55)
    • General register (27)
    • Doc. settlement (2)
    • Period closure (1)
    • Currency exchange rate range (4)
    • Exchange rate conversion (1)
    • Financial accountability articles (4)
      • Financial accountability articles (3)
      • Previous year financial statement data (1)
    • Cost centers (5)
      • Cost centers (4)
      • Cost centers groups (1)
    • Chart of accounts (11)
  • Warehouse (235)
    • Sales (86)
    • Simplified invoicing (10)
    • Client prices (2)
    • Automatic invoicing (1)
    • Purchases (63)
    • Sales return (7)
    • Item stock (9)
    • Item movement (2)
    • Consignment balance (3)
    • Inventory (1)
    • Revalue (1)
    • Internal movement confirmation (1)
    • E-commerce (35)
    • Cash register sales (14)
  • Clients (23)
Category
  • Registers (96)
  •     Item cards (29)
  •         Items (19)
  •         Item attributes (7)
  •         Item groups (2)
  •     Warehouse (48)
  •         Warehouses (3)
  •         Operation types (25)
  •         Doc. series (2)
  •         VAT rates (9)
  •         VAT classification (9)
  •     Intrastat (10)
  •         Intrastat item codes (2)
  •         Intrastat delivery terms (2)
  •         Intrastat transports (2)
  •         Intrastat transactions (2)
  •     Locations
  •     Banks (2)
  •     Currencies (4)
  •     Currency exchange rates (2)
  • Encyclopedia (15)
  • Account (134)
  •     Dashboard (19)
  •     Companies and users (31)
  •     Employee account (17)
  •         Payroll
  •         Requests (2)
  •         Schedule
  •         Information (2)
  •         File upload (8)
  •     My data (24)
  •     Affiliate program (4)
  •     Invites (2)
  •     Reminders (2)
  •     Support (7)
  •     Statistics (4)
  •     Other information (19)
  • Settings (397)
  •     Settings (65)
  •         Users / employees (2)
  •         Sending invoices by email
  •         Self-employed (7)
  •         Approval of documents
  •         Additional sale attributes
  •         Additional item attributes
  •         Additional employee attributes
  •         SAF-T (sttings)
  •         Purchases (2)
  •         Recognition of accounts
  •         System and logos (8)
  •         Data exchange (4)
  •         Bank
  •         Reports (3)
  •         Declarations (9)
  •         Accounting (11)
  •         Stock-taking
  •         Sales (9)
  •         Warehouse
  •     Integrations (319)
  •         API (59)
  •             API (47)
  •             API #2 (10)
  •         Platforms (200)
  •             eBay (28)
  •             Amazon (28)
  •             Shopify (31)
  •             Etsy (28)
  •             Site.pro (23)
  •             Varle.lt (19)
  •             Verskis (21)
  •             Pigu.lt (21)
  •         Cash registers (25)
  •             Raso cash registers (15)
  •             Cash registers (6)
  •             R-Keeper (2)
  •             nSoft
  •             Paysera POS
  •         Paysera (2)
  •         Automatic import of bank statements (via Neopay) (4)
  •         Data exchange with Creditonline.eu
  •         MIP (5)
  •     Data import (12)
  • Declaration (47)
  •     Generate declarations (22)
  •     Declaration signs (2)
  •     i.VAZ (4)
  •     i.SAF (10)
  •     SAF-T
  •     GPAIS (6)
  • Salary (70)
  •     Payroll (31)
  •     Timesheets (7)
  •     Work schedule (2)
  •     Wage prints (14)
  •     Registers (13)
  •         Wage codes (Registers) (5)
  •         Departments (Registers)
  •         Work schedule register (Register)
  •         Salary parameters (Registers) (6)
  • Documents (61)
  •     Orders (31)
  •         Orders (19)
  •         Order attributes (9)
  •         Daily allowance (2)
  •     Insurance
  •         Insurance register
  •     Agreements (2)
  •         Agreements
  •     Emails registry (2)
  •     Outgoing mail register
  •     Incoming / Outgoing document register (2)
  •     Annual leave (17)
  •         Accumulated holiday days (5)
  •         Vacation balances (6)
  •         Vacation balances (4)
  •     Incapacity certificate (2)
  •     Internal documents (2)
  • Assets (21)
  •     Long-term assets (19)
  •         Long-term assets (9)
  •         LTA depreciation (2)
  •         LTA inventory
  •     Low value assets
  •     General report
  • Production (12)
  •     Technological cards (3)
  •     Production from technological cards (5)
  •     Bundle / debundle (4)
  • Dashboard (company) (46)
  • Personnel (40)
  •     Employees (28)
  •     Requests
  •     CV
  •     Registers (8)
  •         Job positions (2)
  •         Employee groups
  •         Tax exempt income (2)
  •         Request types (3)
  • Reports (54)
  •     Inventory report (10)
  •     General ledger reports (16)
  •     Ind. activity report (8)
  •     Sales-purchases (6)
  •     Debt management (4)
  •     Balances / PLN (5)
  •     Other reports (4)
  • Cashier (19)
  •     Cashier (17)
  •     Money receiving receipts
  •     Registers
  •         Responsible persons
  • Bank (61)
  •     Bank (36)
  •     Bank link with cor. account (2)
  •     Import statements (16)
  •     SEPA payments (5)
  • General ledger (55)
  •     General register (27)
  •     Doc. settlement (2)
  •     Period closure
  •     Currency exchange rate range (4)
  •     Exchange rate conversion
  •     Financial accountability articles (4)
  •         Financial accountability articles (3)
  •         Previous year financial statement data
  •     Cost centers (5)
  •         Cost centers (4)
  •         Cost centers groups
  •     Chart of accounts (11)
  • Warehouse (235)
  •     Sales (86)
  •     Simplified invoicing (10)
  •     Client prices (2)
  •     Automatic invoicing
  •     Purchases (63)
  •     Sales return (7)
  •     Item stock (9)
  •     Item movement (2)
  •     Consignment balance (3)
  •     Inventory
  •     Revalue
  •     Internal movement confirmation
  •     E-commerce (35)
  •     Cash register sales (14)
  • Clients (23)
  • Search

    Import statements

    How to import a bank statement in excel format?
    FAQ
    ›
    Import statements
    How to import a bank statement in excel format?

    How to import a bank statement in excel format?

    Before importing a bank statement, you should:

    1. Check Settings → Settings → Data Exchange
      If the fields are empty, we recommend filling them in:

    • Tax correspondent account for statement import – select the correspondent account for bank commission fees;
    • Credit correspondent account for statement import – select the account to be used for settling supplier debts or other outgoing payments;
    • Debit correspondent account for statement import – select the account to be used for settling customer debts or registering incoming payments.

    2. Download the Excel template via: Settings → Data Import → Import of bank Statements
    Select the data import type and click the arrow "Next step".
    3. In the opened window, download the Excel data file template by clicking the "Download Template" button, then click "Next Step".
    When filling out the template, the column values are specified in the B1.lt system — pay attention to which fields are mandatory; optional fields may be left blank.
    Upload the prepared file:
    4.1 Select the file from your device by clicking "Choose File" – the prepared file will be imported automatically.4.2 The completed bank statement Excel template can also be imported via Bank →Import Statement module.
    4.3 Click the button "+" and, in the window that opens, select the "xlsx" format.
    Upload the prepared bank statement file from your device by clicking "Choose File.
    5.The transfer of bank statement data into the accounting system is carried out as usual.
    Note: One file can contain entries from statements of multiple different banks. As long as the entries remain in the Bank → Statement Import module, they do not participate in the accounting records.

    © Site.pro 2011. Website Builder. United States.
    Contact SalesTerms of ServicePrivacy Policy