Site.pro
  • AI Website Builder
    • AI Website Builder
    • Prices
    • Online Stores
    • Collaboration
    • Website Import
    • Plugins
    • Website Builder
    • Templates
    • For Design Studios
    • Languages
    • Affiliate Program
    • Examples
    • For Domain Investors
    • We Build for You
  • Domains
  • Email
  • Accounting Software
    • Accounting Software
    • Modules
    • Prices
    • Integrations, API
    • Accounting companies (366)
    • Software integrators (48)
    • Affiliate Partners
    • Useful Links
    • Business Types
    • Accounting companies
    • Sole Proprietor
    • Invoicing
    • Farmer
    • E-commerce
  • For Resellers
    • Prices
    • White Label
    • Revenue Share
    • Panels
    • How it Works
    • Marketing Materials
    • Mass Import
    • Our Partners
    • Reselling Examples
    • Documentation
    • Free Websites
  • Learn
    • Knowledge Base
    • Tutorials
    • Blog
    • Growth Hacking
    • For Hostings
    • Domainity
    • For Education
    • Accounting: Start of Work
    • Teaching Institutions (68)
    • Accounting Courses Worldwide
    • Online Course on UAE Accounting
  • AI Website Builder
    • AI Website BuilderAI creates websites for you
    • PricesAdvanced Features
    • Online StoresBuild online stores
    • CollaborationCo-create websites live
    • Website ImportImport Any Website
    • PluginsBuilder plugin and functions
    • Website BuilderKey Features
    • Templates200+ Awesome Templates
    • For Design StudiosBenefits for Design Studios
    • Languages
    • Affiliate Program
    • Examples
    • For Domain Investors
    • We Build for You
  • Domains
  • Email
  • Accounting Software
    • Accounting SoftwareCloud based ERP
    • ModulesMain accounting software modules
    • Prices30 days free trial
    • Integrations, APIIntegration with external systems
    • Accounting companies (366)Choose your partner for accounting
    • Software integrators (48)Pick your integrations partner
    • Affiliate PartnersPartners and Affiliate program
    • Useful LinksCalculators and Calendars
    • Business TypesUse cases
    • Accounting companies
    • Sole Proprietor
    • Invoicing
    • Farmer
    • E-commerce
  • For ResellersWhite Label
    • PricesRevenue Share. White Label
    • White LabelCustomise Builder
    • Revenue ShareEarn 50% from each upgrade
    • PanelsOne product for all platforms
    • How it WorksCloud or On-Premises
    • Marketing MaterialsVideo. Mockups. Blocks
    • Mass Import
    • Our Partners
    • Reselling Examples
    • Documentation
    • Free Websites
  • Learn
    • Knowledge BaseFAQ: Builder, Accounting
    • TutorialsDownload for free
    • BlogSite.pro Blog
    • Growth HackingBoost your sales
    • For HostingsTips on marketing
    • DomainityDomain usage by country
    • For EducationTraining. Tutorials
    • Accounting: Start of Work
    • Teaching Institutions (68)
    • Accounting Courses Worldwide
    • Online Course on UAE Accounting
  • Register
    By registering, you accept our Terms of Service
  • Log in

    Log in

    New user? Create account
    Forgot password?
  • $
  • English
  • Account & Billing (32)
    • Account / Profile (8)
    • Payments (7)
  • AI Website Builder (331)
    • Managing Website (14)
    • Website Builder (295)
      • Website creation (59)
      • Text (14)
      • Pictures (11)
      • Media (15)
      • Additional (8)
      • Social (13)
      • SEO (22)
      • Import (7)
      • Commerce (82)
      • Maps (12)
      • Advanced (19)
      • Forms (7)
      • Errors (21)
      • Custom plugins (5)
    • Web Design Studio (3)
    • Affiliate Program (9)
    • Education (10)
  • Domains (42)
    • Purchasing (15)
    • Domain Investors (1)
    • Connecting (26)
  • Mailboxes (26)
  • Accounting Software (706)
    • Dashboard (company) (10)
    • Warehouse (112)
      • Sales (45)
      • 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 (1)
      • Cost centers (2)
      • Chart of accounts (5)
    • Bank (30)
      • Bank (11)
      • Bank link with cor. account (2)
      • Import statements (13)
      • SEPA payments (4)
    • Cashier (4)
      • Cashier (2)
      • Money receiving receipts (1)
      • Reference book (1)
    • Reports (34)
      • Inventory report (8)
      • General ledger reports (9)
      • Ind. activity report (1)
      • Sales-purchases (4)
      • Debt management (4)
      • Balances / PLN (2)
      • Other reports (3)
    • Personnel (24)
      • Employees (17)
      • Requests (1)
      • CV (1)
      • Reference book (5)
        • Job positions (1)
        • Request types (2)
    • Reference book (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)
      • Low value assets (1)
      • General report (1)
    • Documents (32)
      • Orders (15)
        • Orders (8)
        • Order attributes (5)
        • Daily allowance (2)
      • Insurance (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)
      • Reference book (5)
        • Wage codes (Registers) (2)
    • Declaration (42)
      • Generate declarations (16)
      • Declaration signs (1)
      • i.VAZ (14)
        • Clients (11)
      • i.SAF (4)
      • SAF-T (1)
      • GPAIS (6)
    • Settings (161)
      • Settings (33)
        • System and logos (6)
        • Sales (4)
        • Accounting (6)
        • Declarations (1)
        • Data exchange (2)
        • Users / employees (1)
        • Invoices recognition (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 (119)
        • API (22)
          • API (13)
          • API #2 (5)
        • Plugins for E-shops (4)
          • WooCommerce (1)
          • PrestaShop (1)
          • Opencart (1)
          • Adobe Commerce (Magento) (1)
        • Trading Platforms (36)
          • eBay (2)
          • Amazon (3)
          • Shopify (12)
          • Etsy (9)
          • Site.pro (6)
          • Varle.lt (1)
          • Verskis (1)
          • Pigu.lt (1)
        • Cash registers (21)
          • Paysera POS (1)
          • Čekis cash register (1)
          • Raso cash registers (12)
          • Cash registers (5)
          • R-Keeper (1)
          • nSoft (1)
        • Paysera (2)
        • Automatic import of bank statements (5)
        • Creditonline.eu (1)
        • MIP (3)
        • Analytics (2)
      • Data import (9)
    • Account (117)
      • Dashboard (23)
      • Companies and users (29)
      • File upload (8)
      • Employee account (5)
      • My data (19)
      • Affiliate program (4)
      • Invites (2)
      • Reminders (2)
      • Support (7)
        • How to book the program training? (1)
      • Statistics (4)
      • Other information (14)
    • Encyclopedia (14)
  • For Resellers (106)
    • Brand (Cloud, On-Premises) (19)
      • Cloud (5)
      • On-Premises (14)
    • License (34)
    • Installation (16)
      • Website Builder (11)
      • Website Builder Plugin (5)
    • Hosting/Billing Panels (37)
      • WHMCS (5)
      • cPanel (9)
      • DirectAdmin (8)
      • ISPmanager (4)
      • Plesk (7)
      • Webuzo (2)
      • CentOS Web Panel (2)
Category
Search
Filter
  • All (1266)
  • AI Website Builder (328)
  • Domains (45)
  • Email (27)
  • For Resellers (411)
  • Accounting Software (729)
  • How to import a bank statement in excel format?
    FAQ
    ›
    Accounting Software
    ›
    Bank
    ›
    Import statements
    How to import a bank statement in excel format?
    Accounting Software

    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".

    Downloading Excel template for bank statement import

    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.

    Excel data template for bank statement import

    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.

    Uploading prepared bank statement file

    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.

    Importing bank statement file into accounting system

    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:

    Most popular
    • how to import a bank statement in excel format
    Rarely used
    • How do I upload a bank statement in Excel format?
    • How can I bring a bank statement into Excel?
    • How do you add a bank statement as an Excel file?
    • How can I transfer a bank statement to Excel?
    • What’s the process for importing a bank statement into Excel?
    • How do I insert a bank statement into Excel?
    • How can I load a bank statement in Excel format?
    • How do you bring in a bank statement using Excel?
    • How can I upload my bank statement to Excel?
    • How do I convert a bank statement to Excel?
    • How can I move a bank statement into Excel?
    • What’s the method to import a bank statement in Excel?
    • How do you open a bank statement in Excel?
    • How can I input a bank statement in Excel format?
    • How do I transfer a bank statement into Excel?
    • How can I add a bank statement file to Excel?
    • How do you get a bank statement into Excel?
    • What’s the way to import a bank statement to Excel?
    • How can I enter a bank statement into Excel?
    © Site.pro 2011. Website Builder. United States.
    Contact SalesTerms of ServicePrivacy Policy