Forensic Accounting, Reconstruction, Auditing and Cleanup of Financial Records

Banana Accounting is a professional, international accounting software designed to support structured financial analysis and reconstruction. It is particularly effective when accounting records must be rebuilt, reconciled, audited, verified, or reorganized in a clear and reliable way.

Banana Accounting brings exceptional flexibility to accounting professionals. It combines the speed and flexibility of a spreadsheet with the structure and control of double-entry accounting. Features such as investment accounting and powerful filtering tools — often unavailable in traditional ERP systems — make it a superior and simpler solution for cleaning up accounting records, managing parallel accounting files, reconstructing accounts, and verifying financial data.

The software automatically generates key financial reports — including balance sheets, income statements, account cards, and detailed transaction listings — enabling a clear assessment of the financial position and the preparation of documentation suitable for auditors, experts, legal professionals, or courts.

Most accounting systems used in daily bookkeeping are optimized for routine operations and compliance, not for reconstruction work. As a result, many professionals rely on Excel for corrective or investigative tasks. However, spreadsheets do not enforce double-entry consistency and can easily introduce errors. Banana Accounting offers a structured alternative, combining transparency, speed, and accounting discipline.

This documentation introduces the principles of forensic accounting and the cleanup and reconstruction of financial records, and explains how Banana Accounting can be used to support these activities effectively.

Accounting Cleanup

Accounting cleanup refers to the systematic correction and reorganization of financial records that have become inaccurate, inconsistent, or incomplete during normal business operations. It is commonly required when a CPA takes over a new client, prepares year-end financial statements, or discovers discrepancies during routine review work.

Typical cleanup tasks include reconciling bank and credit card accounts, resolving unexplained balances, correcting misclassified transactions, rebuilding opening balances, clearing suspense or temporary accounts, and ensuring that receivables, payables, and tax liabilities are properly stated. In some cases, it may also involve partially reconstructing prior periods to restore continuity and accuracy.

The objective of accounting cleanup is to re-establish a coherent and internally consistent accounting structure that produces reliable financial statements. Unlike daily bookkeeping, cleanup work focuses on identifying accumulated errors and restoring confidence in the underlying data before further reporting, advisory, or tax activities can proceed.

Auditing of Accounting

The auditing process often requires checking the accounting data managed with the company’s accounting software. In many cases, the accounting software does not provide the tools needed for this work. As a result, auditors often export the data and rebuild the accounting situation in Excel.

A useful alternative is to import the chart of accounts and the transactions into Banana Accounting. The program is based on double entry accounting logic and rebuilds the accounting situation from the start. This makes it possible to verify that the results match correctly.

Once the data is in Banana Accounting, it becomes easier to perform additional checks, filter the information, and export the data to other formats. 

Accounting Reconstruction

Accounting Reconstruction is the rapid and systematic restoration and analysis of financial information in cases of fraud, legal disputes, insolvency, data loss, or abrupt management changes, when reliable accounting records are missing, incomplete, or inconsistent. It may also be necessary to obtain more detailed information when the current system does not allow it, for example during an M&A due diligence process.

The primary objective is to swiftly rebuild a structured and verifiable accounting system from available source documents, including bank statements, invoices, contracts, and tax filings. By organizing transactions through the double-entry bookkeeping method, Backlog Accounting Reconstruction ensures internal data consistency, highlights discrepancies, and restores full operational control over financial records.

The final output is a clear, accurate, and legally defensible representation of the organization’s financial position—including the Balance Sheet, Income Statement, and detailed transaction ledgers—enabling informed decision-making in legal, financial, or operational contexts.

Emergency accounting is the rapid reconstruction and analysis of financial information in crisis situations, such as fraud, disputes, insolvency, data loss, or sudden management changes, when reliable accounting records are missing, incomplete, or inconsistent.

Forensic accounting

Forensic Accounting is the application of accounting and auditing techniques to legal, judicial, and investigative matters. The goal is to reconstruct the financial truth when data is missing, incomplete, manipulated, or suspicious. Financial investigations often analyze existing accounting records and require a solid understanding of accounting practices. They are usually conducted by experienced accountants, often with specific training.

The popularity of crime investigation series like CSI has led to associating the term "forensic" mainly with crimes such as fraud or money laundering. In reality, it also includes the collection of evidence and investigations in civil matters, such as shareholder or inheritance disputes, or in tax cases like overdue taxes.

Forensic accounting includes all investigative activities related to reconstructing financial situations, such as:

• Legal audits, assessments, financial consulting, damage quantification, and analysis.
• Bankruptcies, company liquidations, and financial restructurings.
• Disputes between partners, inheritance transfers, or checks during due diligence.
• M&A due diligence. 
• Legal and tax compliance failures.
• Fraud, bankruptcy, or money laundering.
• Monitoring the use of funds, illegal expenses, and corruption.
• Lack of access to or problems with the original IT system.

Shortcomings of Pre-Existing Tools

Professional accountants and CPAs already rely on established tools such as ERP systems, accounting platforms, and spreadsheets. These solutions are highly effective for routine bookkeeping, compliance, payroll processing, and periodic reporting.

However, situations involving reconstruction, cleanup, data verification, due diligence, or other non-recurring operations present different requirements. These tasks are exploratory, corrective, and often temporary in nature. They require flexibility, transparency, and the ability to reorganize data without disrupting operational systems.

In these contexts, traditional tools may reveal structural limitations.

Shortcomings of ERP and Standard Accounting Systems

Enterprise accounting software and ERP systems are designed primarily for structured, ongoing operations. They are optimized for efficiency, internal control, and compliance within a stable workflow.

In reconstruction or cleanup scenarios, these characteristics can become constraints:

• Rigid process flows and approval structures.
• Complexity caused by the need to cover all requirements.
• Multiple integrated modules that do not communicate well with each other.
• Reduced transparency and control due to increased automation. 
• Standardized charts of accounts and predefined reporting formats.
• Emphasis on periodic tax and regulatory reporting.
• Many constrains importing and reorganizing raw transactional data.
• Risk associated with modifying historical records in live systems.
• Difficulty testing alternative classifications or adjustments without affecting official books.
• Vendor lock-in, with the need to move to a more expensive version to access certain features.

Such systems are excellent for daily operations but are not specifically designed for investigative, corrective, or one-time analytical work.

Shortcomings of Excel

When faced with reconstruction or cleanup tasks, many professionals turn to Excel because it allows rapid data collection, filtering, and analysis. Spreadsheets are flexible and familiar, and they support quick experimentation.

However, Excel lacks the structural safeguards of accounting software:

• It requires careful management of formulas and links.
• It does not enforce double-entry accounting logic.
• It does not automatically ensure that debits and credits balance.
• Categorization is manual and not inherently based on accounting rules.
• Standard financial statements must be built manually.
• Errors can remain undetected in complex models.

Excel is a powerful analytical tool, but it was not designed to function as a controlled accounting system.

Banana Accounting for Reconstruction and Cleanup

Reconstruction, cleanup, and other non-recurring accounting tasks require a working environment that combines flexibility with accounting control. Banana Accounting provides a structured and independent space where financial data can be reorganized, verified, and recalculated without affecting the operational system.

Unlike ERP systems, it is not constrained by rigid workflows. Unlike spreadsheets, it enforces double-entry consistency automatically.

Banana Accounting allows professionals to:

• Work in a separate accounting file without modifying the client’s live system.
• Import and reorganize raw transactional data quickly.
• Use a fully customizable chart of accounts.
• Automatically ensure debit/credit balance and internal consistency.
• Detect discrepancies through built-in double-entry controls.
• Test reclassifications and adjustments safely.
• Instantly generate balance sheets, income statements, and detailed account cards.
• Present results in a clear and professionally recognized accounting format.

By combining spreadsheet flexibility with accounting discipline, Banana Accounting bridges the gap between rigid ERP systems and unstructured Excel files, making it particularly suited for reconstruction and cleanup work.

Similar to Excel 

Banana Accounting is similar to Excel, does not require specific training, and offers great flexibility. It is therefore a very useful tool for reconstructing financial situations and managing accounting for forensic analysis.

• The accounting is a file that contains multiple tables.
• The tables are similar to Excel sheets: you can move freely, insert and select cells, copy and paste.
• You can create as many files as you want, each with its own settings.
• The file can be saved and moved wherever you want. 

Local data management

Unlike other accounting software that operates only in the cloud, Banana Accounting allows you to choose where to save and store your accounting file. This way, you can keep your data locally without uploading it to cloud systems, avoiding the need for specific authorizations. Accounting records can be easily linked to digital supporting documents stored on your computer, allowing you to quickly and thoroughly check the reason for specific expenses during data analysis.

This feature can be especially useful in the preliminary analysis phase, not only for privacy reasons but also because it makes it easier to share information and reuse data in later stages.

Importing data 

Banana Accounting is based on tables, so it is quite easy to import existing data, whether it concerns the chart of accounts, customers or suppliers, product or investment lists, VAT codes, or other information. For more information, please refer to the page:

• Importing data from other programs.
• Once you have imported the data you can complete it and modify.
• You can filter, select multiple cells, copy and paste, search and replace, and fix multiple rows almost instantly. 
• You can undo and redo operations. 

Ideal for various fields

Banana Accounting is not a specialized forensic analysis software, but it can be extremely helpful for professionals such as:

• Accountants and auditors.
• Family offices.
• Fiduciary, financial, and real estate management firms.
• Lawyers and law firms.
• Restructuring specialists.
• Court-appointed or party-appointed technical consultants.
• Inspectors or experts working within legal teams.
• Departments of large organizations. 

Try Banana Accounting with the WebApp

If you want to see how easy it is to collect and categorize accounting data:

• See how to get started with double-entry accounting, including a short explanatory video.
• Try the Banana Accounting WebApp, which runs directly in your browser (no registration required):
  it’s the fastest way to test, set up an accounting file, and start entering data.
  These links launch the WebApp and open one of the universal templates, not tied to any specific country:
  • Double-entry accounting - Business plan and financial planning for a startup
  • Double-entry accounting with multi-currency - Financial company and portfolio management (chart of accounts in English)
  • Cash Manager - Cash flow plan for freelancers and small businesses

To manage accounting regularly and completely, we recommend using the desktop version of Banana Accounting (to download and install on your computer). The Free plan of Banana Accounting lets you create accounting files and use most features, with a saving limit of 70 transactions. It's the ideal way to get started and see if the tool fits your needs.

Our customer service is available for more information. Our specialists can also advise you on how to proceed with data recovery or other specific needs.

Use Banana Accounting for Reconstructing the Financial Situation

Below you’ll find an explanation of how to use Banana Accounting to reconstruct accounting records for forensic accounting activities.
Keep in mind that reconstruction can be done in two phases:

• Preliminary data collection and analysis to assess the situation.
• Data collection and analysis with more specific goals.

The financial reconstruction, whether preliminary or final, is generally structured as follows:

• Defining the objectives of the investigation.
• Collecting documents, bank statements, and other financial information.
• Re-entering transactions into an accounting system, completing and categorizing them.
• Verifying, evaluating, and analyzing the data.
• Presenting the financial information.
• Economic and legal evaluations, with preparation of reports. 

Create accounting starting from a template 

What makes Banana Accounting particularly suitable for forensic accounting is that it is a professional international accounting tool, not designed solely for corporate accounting. It is modular, so you can have double-entry accounting setups for foundations, associations, individuals, in different currencies and languages. For simpler situations, you can also use the income & expense method, which can still manage the balance sheet.

To start a new accounting file, use a predefined template for a specific purpose:

• Menu File > New.
  A dialog will appear where you can choose a template by region and type of accounting.
• Templates for specific regions.
  These are set up according to national accounting standards.
  The chart of accounts usually has numerical account IDs.
• Universal templates.
  These are for more general use. The account IDs are usually descriptive text.

Chart of accounts and opening balances

After choosing the template that best suits your needs, you will need to customize the Accounts table by modifying, adding, or removing accounts. You can adjust the chart of accounts and grouping structure at any time.

You can create account plans with grouping structures that reflect those used in existing accounting systems managed with other software.

If you're reconstructing an accounting file, you will likely need to enter opening balances using the “Opening” column in the Accounts table.

Note that in Banana Accounting’s double-entry system, amounts are displayed according to the logic of accounting programs, so Debit amounts are positive and Credit amounts are negative. Opening balances in Credit must therefore be entered as negative values.

Entering and importing transactions

In the Transactions table you enter accounting transactions:

• You can enter and edit them manually.
  • Entering and modifying data within the tables is very easy.
  • You can copy and paste from Excel or other programs. 
  • In the Recurring Transactions table you can set up repeating entries.
• You can import data:
  • You can import from CSV or other file formats.
  • You can import digital bank statements.
    • Several import extensions are available.
    • You can create Import Rules that automatically complete the offset account and other elements.
• Modify and complete the transactions:
  • When you enter or import transactions, the software will alert you to any errors or differences.
  • You can apply rules for automatic completion.
  • You can modify the transactions.

Banana Accounting was designed for small businesses, but in theory, there are no limits to the number of transactions or accounts you can manage. The software keeps all data in memory, so performance depends on your computer’s RAM and processor. Some clients successfully manage very large accounting files, with tens of thousands of accounts and hundreds of thousands of entries.

Automatic transaction categorization

Banana Accounting provides a deterministic rule system, configured by the accountant, to automatically categorize and complete transactions imported from bank statements. Thanks to these rules, you can quickly process large volumes of data. The applied rules are always visible in the Recurring Transactions table, where they can be printed and reviewed by auditors. Still, it is good practice to always check individual account statements.

There are many tools that digitize paper documents and, through artificial intelligence, extract information, analyze, and categorize content based on probabilistic logic. These tools can be very helpful and save time. However, it's important to note that categorization based on probabilistic logic is not a reliable source and always requires thorough verification.

AI-based tools often allow data export in CSV or Excel format, so you can easily import the data into Banana Accounting for manual review, corrections, and completion.

Review and add additional information

Once transactions are imported, you can review, edit, and complete them manually with the information you need:

• You can highlight and color rows, bold them, or change font size.
• Using the Data > Arrange Columns menu:
  • You can show pre-configured columns (e.g. Notes, Links),
  • You can add new types of columns.
• You can add links to supporting digital documents.
• You can use:
  • Cost and profit centers – to categorize transactions in different ways.
  • Segments – to divide activity by areas, branches, or other categories.

Error detection, reconciliation, and closing procedures

Banana Accounting provides built-in tools for identifying errors, performing reconciliations, and preparing adjusting entries and period-end closings. Thanks to the double-entry structure, inconsistencies are immediately visible, and the accounting check function systematically verifies the chart of accounts and all recorded transactions.

Bank and account reconciliations are simplified through clear account cards, transaction filtering, balance controls, and automatic calculation of differences. This makes it easier to detect missing entries, duplicated postings, or incorrect classifications.

The structured framework also supports the preparation of accruals, deferrals, provisions, and other adjusting entries required for accurate financial reporting. As a result, period-end closings can be completed efficiently and with a high level of reliability, even in complex reconstruction or investigative contexts.

Filtering and other useful features 

There are many useful features that allow you to analyze and complete data quickly, including:

• The Balance column in the Transactions table indicates if there is an imbalance between Debit and Credit, due to account coding errors or unbalanced multi-account entries.
• The Temporary row filter function shows only the rows containing a specific text. There is also advanced syntax available for more powerful searches.
  When the filter is active, you can edit transaction content, select, copy, and paste cells just like in Excel.
• With Temporary row sorting, you can view rows in ascending or descending order based on a column. You can remove the temporary sort to return to the original order.
• Find and replace.
• The Copy rows command copies the selection with column headers. When you paste into Excel, the headers are already included so you can easily apply filters or create pivot tables.
• The Check accounting tool rechecks the chart of accounts and all entries and alerts you if there are errors or discrepancies.

Balance sheet and Account cards 

The main advantage of Banana Accounting compared to Excel is that, once transactions are entered, you automatically get the Balance Sheet, the Income Statement, and the account cards for each account.

In the Accounts table, you have an immediate view of all accounts and groups, with updated movements and balances. This way you instantly see the current situation of your Balance Sheet and Income Statement. Of course, it’s essential to verify that bank balances match those in your accounting.

Additional accounting features 

At any time, you can adapt your accounting setup and add or remove features. See:

• Additional accounting features.

Extensions 

Banana Accounting, like Excel, provides a programming language that allows you to perform all kinds of processing.
It is commonly used to create custom reports, but it can also be used, for example, to create import extensions or modify existing data:

• Create extensions for Banana Accounting
• Information on importing data into Banana Accounting
• Information on exporting data from Banana Accounting

We have also created ChatGPT assistants to help you create extensions for generating reports. The extensions run locally in Banana, so you don’t need to send your data to the cloud AI assistant.