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
    • 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
    • TutorialsVideos for Beginners. Download video tutorials for free
    • 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
  • Dashboard (company) (17)
  • Warehouse (108)
    • Sales (41)
    • Simplified invoicing (5)
    • Client prices (1)
    • Automatic invoicing (1)
    • Purchases (26)
    • Sales return (6)
    • Item stock (1)
    • Item movement (1)
    • Consignment balance (1)
    • Inventory (1)
    • Revalue (1)
    • Internal movement confirmation (1)
    • E-commerce (17)
    • Cash register sales (5)
  • General ledger (32)
    • General register (16)
    • Doc. settlement (2)
    • Period closure (1)
    • Currency exchange rate range (3)
    • Financial accountability articles (2)
      • Financial accountability articles (1)
    • Cost centers (3)
      • Cost centers (2)
      • Cost centers groups (1)
    • Chart of accounts (5)
  • Bank (30)
    • Bank (11)
    • Bank link with cor. account (2)
    • Import statements (13)
    • SEPA payments (4)
  • Cashier (3)
    • Cashier (1)
    • Money receiving receipts (1)
    • Registers (1)
      • Responsible persons (1)
  • Reports (33)
    • Inventory report (8)
    • General ledger reports (9)
    • Ind. activity report (1)
    • Sales-purchases (4)
    • Debt management (4)
    • Balances / PLN (2)
    • Other reports (3)
  • Personnel (22)
    • Employees (14)
    • Requests (1)
    • CV (1)
    • Registers (6)
      • Job positions (1)
      • Tax exempt income (2)
      • Request types (2)
  • Registers (26)
    • Item cards (5)
    • Warehouse (10)
      • Warehouses (2)
      • Operation types (5)
    • Intrastat (6)
    • Locations (1)
    • Banks (1)
    • Currencies (2)
    • Currency exchange rates (1)
  • Production (5)
    • Technological cards (1)
    • Production from technological cards (2)
    • Bundle / debundle (2)
  • Assets (15)
    • Long-term assets (13)
      • Long-term assets (13)
    • Low value assets (1)
    • General report (1)
  • Documents (32)
    • Orders (15)
      • Orders (8)
      • Order attributes (5)
      • Daily allowance (2)
    • Insurance (1)
      • Insurance register (1)
    • Agreements (1)
      • Agreements (1)
    • Emails registry (2)
    • Outgoing mail register (1)
    • Incoming / Outgoing document register (1)
    • Annual leave (7)
      • Accumulated holiday days (2)
      • Vacation balances (3)
    • Incapacity certificate (2)
    • Internal documents (2)
  • Salary (48)
    • Payroll (25)
    • Timesheets (6)
    • Work schedule (1)
    • Wage prints (11)
    • Registers (5)
      • Wage codes (Registers) (2)
  • Declaration (41)
    • Generate declarations (15)
    • Declaration attributes (1)
    • i.VAZ (14)
      • Clients (11)
    • i.SAF (4)
    • SAF-T (1)
    • GPAIS (6)
  • Settings (198)
    • Settings (33)
      • System and logos (6)
      • Sales (4)
      • Accounting (6)
      • Declarations (1)
      • Data exchange (2)
      • Users / employees (1)
      • Recognition of accounts (1)
      • Additional employee attributes (1)
      • Additional item attributes (1)
      • Additional sale attributes (1)
      • Approval of documents (1)
      • Self-employed (1)
      • Sending invoices by email (1)
    • Integrations (156)
      • API (23)
        • API (14)
        • API #2 (5)
      • Plugins for E-shops (20)
        • WooCommerce (5)
        • PrestaShop (5)
        • Opencart (5)
        • Adobe Commerce (Magento) (5)
      • Trading Portals (55)
        • eBay (8)
        • Amazon (9)
        • Shopify (12)
        • Etsy (9)
        • Site.pro (6)
        • Varle.lt (2)
        • Verskis (5)
        • Pigu.lt (4)
      • Cash registers (21)
        • Raso cash registers (12)
        • Cash registers (6)
        • R-Keeper (1)
        • nSoft (1)
        • Paysera POS (1)
      • Paysera (2)
      • Automatic import of bank statements (via Neopay) (4)
      • Data exchange with Creditonline.eu (2)
      • MIP (5)
    • Data import (9)
  • Account (116)
    • Dashboard (20)
    • Companies and users (28)
    • File upload (8)
    • Employee account (5)
    • My data (22)
    • Affiliate program (4)
    • Invites (2)
    • Reminders (2)
    • Support (7)
    • Statistics (4)
    • Other information (14)
  • Encyclopedia (15)
Category
  • Dashboard (company) (17)
  • Warehouse (108)
  •     Sales (41)
  •     Simplified invoicing (5)
  •     Client prices
  •     Automatic invoicing
  •     Purchases (26)
  •     Sales return (6)
  •     Item stock
  •     Item movement
  •     Consignment balance
  •     Inventory
  •     Revalue
  •     Internal movement confirmation
  •     E-commerce (17)
  •     Cash register sales (5)
  • General ledger (32)
  •     General register (16)
  •     Doc. settlement (2)
  •     Period closure
  •     Currency exchange rate range (3)
  •     Financial accountability articles (2)
  •         Financial accountability articles
  •     Cost centers (3)
  •         Cost centers (2)
  •         Cost centers groups
  •     Chart of accounts (5)
  • Bank (30)
  •     Bank (11)
  •     Bank link with cor. account (2)
  •     Import statements (13)
  •     SEPA payments (4)
  • Cashier (3)
  •     Cashier
  •     Money receiving receipts
  •     Registers
  •         Responsible persons
  • Reports (33)
  •     Inventory report (8)
  •     General ledger reports (9)
  •     Ind. activity report
  •     Sales-purchases (4)
  •     Debt management (4)
  •     Balances / PLN (2)
  •     Other reports (3)
  • Personnel (22)
  •     Employees (14)
  •     Requests
  •     CV
  •     Registers (6)
  •         Job positions
  •         Tax exempt income (2)
  •         Request types (2)
  • Registers (26)
  •     Item cards (5)
  •     Warehouse (10)
  •         Warehouses (2)
  •         Operation types (5)
  •     Intrastat (6)
  •     Locations
  •     Banks
  •     Currencies (2)
  •     Currency exchange rates
  • Production (5)
  •     Technological cards
  •     Production from technological cards (2)
  •     Bundle / debundle (2)
  • Assets (15)
  •     Long-term assets (13)
  •         Long-term assets (13)
  •     Low value assets
  •     General report
  • Documents (32)
  •     Orders (15)
  •         Orders (8)
  •         Order attributes (5)
  •         Daily allowance (2)
  •     Insurance
  •         Insurance register
  •     Agreements
  •         Agreements
  •     Emails registry (2)
  •     Outgoing mail register
  •     Incoming / Outgoing document register
  •     Annual leave (7)
  •         Accumulated holiday days (2)
  •         Vacation balances (3)
  •     Incapacity certificate (2)
  •     Internal documents (2)
  • Salary (48)
  •     Payroll (25)
  •     Timesheets (6)
  •     Work schedule
  •     Wage prints (11)
  •     Registers (5)
  •         Wage codes (Registers) (2)
  • Declaration (41)
  •     Generate declarations (15)
  •     Declaration attributes
  •     i.VAZ (14)
  •         Clients (11)
  •     i.SAF (4)
  •     SAF-T
  •     GPAIS (6)
  • Settings (198)
  •     Settings (33)
  •         System and logos (6)
  •         Sales (4)
  •         Accounting (6)
  •         Declarations
  •         Data exchange (2)
  •         Users / employees
  •         Recognition of accounts
  •         Additional employee attributes
  •         Additional item attributes
  •         Additional sale attributes
  •         Approval of documents
  •         Self-employed
  •         Sending invoices by email
  •     Integrations (156)
  •         API (23)
  •             API (14)
  •             API #2 (5)
  •         Plugins for E-shops (20)
  •             WooCommerce (5)
  •             PrestaShop (5)
  •             Opencart (5)
  •             Adobe Commerce (Magento) (5)
  •         Trading Portals (55)
  •             eBay (8)
  •             Amazon (9)
  •             Shopify (12)
  •             Etsy (9)
  •             Site.pro (6)
  •             Varle.lt (2)
  •             Verskis (5)
  •             Pigu.lt (4)
  •         Cash registers (21)
  •             Raso cash registers (12)
  •             Cash registers (6)
  •             R-Keeper
  •             nSoft
  •             Paysera POS
  •         Paysera (2)
  •         Automatic import of bank statements (via Neopay) (4)
  •         Data exchange with Creditonline.eu (2)
  •         MIP (5)
  •     Data import (9)
  • Account (116)
  •     Dashboard (20)
  •     Companies and users (28)
  •     File upload (8)
  •     Employee account (5)
  •     My data (22)
  •     Affiliate program (4)
  •     Invites (2)
  •     Reminders (2)
  •     Support (7)
  •     Statistics (4)
  •     Other information (14)
  • Encyclopedia (15)
  • Search

    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 Site.pro 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.


    People also found this article using these queries:

    • kaip importuoti banko išrašą excel formatu
    • how to import a bank statement in excel format
    • prieš darant banko išrašo importą reikia: 1. patikrinti parametrai nustatymai duomenų mainai jei laukai tušti, rekomenduojame užpildyti: mokesčių kor. sąskaita importuojant išrašus parenkama banko komisinių kor.sąskaita kredito kor. sąskaita importuojant išrašus parenkama kor sąskaita, kuri bus naudojama dengti skolas tiekėjams arba kitos išmokėtos sumos debeto kor. sąskaita importuojant išrašus parenkama kor. sąskaita, kuri bus naudojama dengianti pirkėjų skolas arba registruoti gautas įplaukas 2. atsisiųsti excel šabloną: parametrai duomenų importas banko išrašų importas pasirinkti duomenų importo tipą ir spausti ant rodyklės ,,kitas žingsnis 3. atsidariusiame lange parsisiųsti duomenų failo excel šabloną, spausti mygtuką parsisiųsti šabloną ir spausti mygtuką kitas žingsnis .šablono užpildymui stulpelių reikšmės nurodytos b1.lt programoje, atkreipti dėmesį kurie laukai yra privalomi, neprivalomi laukai gali likti neužpildyti. 4. įkelti paruoštą failą:4.1 failą pasirinkti iš savo įrenginio spaudžiant ant pasirinkti failą : automatiškai importuojamas paruoštas failas 4.2 užpildyta banko išrašo excel šabloną galima importuoti ir per bankas išrašų importas modulį modulyje bankas išrašų importas galima rasti importuotus banko duomenis.4.3 spausti mygtuką ir lange pasirinkti xlsx formatą: įkelti pasiruoštą banko išrašo failą iš savo įrenginio spaudžiant pasirinkite failą .5. banko išrašo duomenų perkėlimas į apskaitą atliekamas įprastai. pastaba. viename faile galima registruoti kelis skirtingų bankų išrašo įrašus. kol įrašai yra bankas išrašų importas modulyje, įrašai nedalyvauja apskaitoje..
    • before importing a bank statement, you should: 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..
    • как импортировать выписку из банка в формате excel
    • ar galiu importuoti visų bankų išrašus
    • ką daryti, jei nerandu reikiamo banko sąraše importui atlikti
    • ar galiu importuoti bet kurį banką
    • kaip įkelti paruoštą banko išrašo excel failą į sistemą
    • kuriuos laukus reikia užpildyti banko išrašo šablone, o kurie gali likti neužpildyti
    • kaip užpildyti banko išrašo excel šabloną
    • kaip atsisiųsti excel šabloną banko išrašui importuoti
    • kokius parametrus reikia patikrinti prieš importuojant banko išrašą excel formatu
    • jei nerandu tinkamo banko, ar galiu kelti išrašą į programą
    • kur rasti šabloną banko išrašo importui atlikti
    © Site.pro 2011. Website Builder. United States.
    Contact SalesTerms of ServicePrivacy Policy