Import bank transactions from a spreadsheet | Pixie CRM Help Centre Canonical: https://pixiecrm.com/help-centre/import-bank-transactions-from-a-spreadsheet Publisher: Pixie Technologies LLC Accounting & Bookkeeping · How-to guide Import bank transactions from a spreadsheet Pixie CRM guidance. Follow the route for your workspace, check your role and enabled modules, and verify the result before moving on. Follow this guide to use the supplied banking import format to load statement transactions when a connected feed is unavailable or inappropriate. Audience: Accounting staff; Feature: Bank import; Module v1.4.5; Where to goAccounting → Banking (https://pixiecrm.com/help-centre/topic/banking) → Import Banking (https://pixiecrm.com/help-centre/topic/banking) Before you startThis guide follows Accounting and Bookkeeping module version 1.4.5. The required access is Accounting Banking (https://pixiecrm.com/help-centre/topic/banking): Create. A related screen can remain hidden when an optional module is inactive, a source record is in an ineligible status, the selected account is inactive or the user is not an assigned approver (https://pixiecrm.com/help-centre/topic/approval). What you’ll accomplish Use the supplied banking (https://pixiecrm.com/help-centre/topic/banking) import format to load statement transactions when a connected feed is unavailable or inappropriate. It forms part of Pixie CRM Enterprise CRM's Accounting & Bookkeeping module and uses the module's permission-aware controller, status and mapping (https://pixiecrm.com/help-centre/topic/mapping) flow rather than a generic spreadsheet process. How it works The module includes sample banking (https://pixiecrm.com/help-centre/topic/banking) workbooks, an import screen, import table and file-processing actions. It also supports importing edited feed spreadsheets separately. Imported bank rows enter the review workflow and are not necessarily posted to the ledger. Add, match, ignore or apply rules after review. Use statement totals and reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) to detect missing or duplicate lines. Follow these steps - Download the banking (https://pixiecrm.com/help-centre/topic/banking) sample file. - Prepare a small date range from the official statement. - Keep headers and date formats unchanged. - Select the correct Accounting bank account (https://pixiecrm.com/help-centre/topic/banking). - Upload and run the import. - Check imported and rejected rows. - Compare opening, closing and transaction totals with the statement. Settings to check Sample workbookDefines the accepted columns and data format. Bank account (https://pixiecrm.com/help-centre/topic/banking)Determines which feed and register receive the imported rows. DateMust match the statement transaction date. Description, payee and referenceSupport rule and match logic. Withdrawal and depositUse the correct direction. Unique transaction dataHelps identify duplicates. Check it worked After the action is saved, Pixie CRM keeps the Accounting record connected to its source and updates the visible status or ledger data supported by this workflow. Review the saved result rather than relying only on a success message. Where the action posts accounting data, total debits and credits (https://pixiecrm.com/help-centre/topic/double-entry) must balance and the accounts must match the approved mapping (https://pixiecrm.com/help-centre/topic/mapping) or manual selection. - Open the saved record and confirm its final status. - Review the source reference and every debit and credit (https://pixiecrm.com/help-centre/topic/double-entry) line where ledger data was created. - Use the relevant register, ageing, reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) or report (https://pixiecrm.com/help-centre/topic/report) to verify the wider effect. Common mistakes to avoid - Do not import the same statement range twice. - Do not reverse deposit and withdrawal columns. - Keep bank data confidential. - Correct rejected rows in a new controlled file. - Use the least destructive correction available and record the reason for material changes. - Do not bypass a permission, approval (https://pixiecrm.com/help-centre/topic/approval) or closed-period control by changing unrelated data. Accounting and data safetyDeletion, reset, void, refund, mapping (https://pixiecrm.com/help-centre/topic/mapping), journal and reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation) actions can change financial history. Use approved access, retain supporting evidence and validate the result in the General Ledger or relevant control report (https://pixiecrm.com/help-centre/topic/report). Browse connected topics:payment (https://pixiecrm.com/help-centre/topic/payment)banking (https://pixiecrm.com/help-centre/topic/banking)reconciliation (https://pixiecrm.com/help-centre/topic/reconciliation)check (https://pixiecrm.com/help-centre/topic/check)report (https://pixiecrm.com/help-centre/topic/report)approval (https://pixiecrm.com/help-centre/topic/approval)mapping (https://pixiecrm.com/help-centre/topic/mapping)double-entry (https://pixiecrm.com/help-centre/topic/double-entry)Plaid (https://pixiecrm.com/help-centre/topic/plaid) Related guides Review and edit banking feeds (https://pixiecrm.com/help-centre/review-and-edit-banking-feeds)Export, edit and re-import banking feeds (https://pixiecrm.com/help-centre/export-edit-and-reimport-banking-feeds)Reconcile a bank account (https://pixiecrm.com/help-centre/reconcile-a-bank-account)Create banking rules (https://pixiecrm.com/help-centre/create-banking-rules)Banking workspace overview (https://pixiecrm.com/help-centre/banking-workspace-overview)Create and manage an Accounting bank account (https://pixiecrm.com/help-centre/create-an-accounting-bank-account)