Accounting and Bookkeeping module for Perfex CRM

Note: This is a module for Perfex CRM. Not a standalone script.

Brief description

Accounting is the process of recording and tracking financial statements to see the financial health of an entity. This is done by inputting, sorting, measuring, and then communicating transactions in various formats. Accounting consists of bookkeeping and analysis. Bookkeeping, or financial accounting, consists of recording transactions, which can include purchases, sales, and receipts of an individual or an organization. Once the bookkeeper records and organizes all of the transactions, the next step of accounting is to analyze these transactions into helpful reports which will show the state of one’s finances. These reports can include profit/loss statements, cash flow reports, and can track sales tax to keep a close eye on what is owed come tax time. With small business accounting done right, small business owner will be able to have a clear understanding of the state of your finances so you can make better decisions based on what you have available.

The benefits of a Accounting & Bookkeeping module

Using this module helps in relieving the burden of manual data entry, prevents common human errors, helps businesses and accountants when tax time comes around and allows the user to look at in-depth reports of how their business’ finances are faring. Perhaps the biggest advantage of this module is all of the time it will save. With this module, all of their financial reports will be consolidated into one online system, making it easier to keep track of their records. An accounting module for businesses offers the ability to automate many processes which will not only save time but will also ensure accuracy and efficiency with one’s financial reports.

Module Features

1. Dashboard: Profit & Loss Chart, Income Chart, Expense Chart, Cashflow Chart and Bank Accounts Overview
2. Banking:
   • Bank Accounts Management
   • Banking Feeds: Download Transactions, Import Transactions, Add/Edit/Delete Transactions, Match/Ignore Transactions, Verify Account
3. Transactions Management:
   • Mapping Bank Statements to Accounting
   • Mapping Invoices to Accounting
   • Mapping Payments to Accounting
   • Mapping Expenses to Accounting
   • Mapping Purchase to Accounting (need to integrate with Purchase Management module)
   • Mapping Inventory to Accounting (need to integrate with Inventory Management module)
   • Mapping Payroll to Accounting (need to integrate with HR Payroll module)
   • Mapping Manufacturing to Accounting (need to integrate with Manufacturing Management module for Perfex CRM)
   • Mapping Assets to Accounting (need to integrate with Fixed Equipment Management module for Perfex CRM)
   • Mapping Sales Order Return to Accounting (need to integrate with Omni Channel Sales module for Perfex CRM)
   • Mapping Sales Refund to Accounting (need to integrate with Omni Channel Sales module for Perfex CRM)
4. Bills Management
5. Checks Management
6. Register is where you quickly enter money you have received from your customers and payments you have made to your suppliers or vendors
7. Banking Rules: to automatically categorize transactions
8. Journal Entry: to record transactions in the general ledger
9. Transfer: to transfers of amounts between accounts
10. Chart of Accounts: is a list of the account numbers and names relevant to your company. Typically, a chart of accounts will have four categories (Asset accounts, Liability accounts, Income accounts and Expense accounts).
11. Reconcile: is the process of matching transactions entered into module against your bank or credit card statements
12. Budgets Management: supports preparing budgets, which help you monitor, track, and compare expected income and expenses with actual income and expenses. When you prepare a budget, you typically prepare it for a fiscal year, and you can opt to supply budget amounts or use historical amounts
13. Mapping Setup:
    • General Mapping Setup
    • Payslips Mapping Setup
    • Purchase Mapping Setup
    • Inventory Mapping Setup
    • Manufacturing Mapping Setup
    • Omni-channel Sales Mapping Setup
    • Fixed Equipment Mapping Setup
14. Business Overview Reports:
    • Balance Sheet Comparison: what you own (assets), what you owe (liabilities), and what you invested (equity) compared to last year.
    • Balance Sheet Detail: a detailed view of what you own (assets), what you owe (liabilities), and what you invested (equity).
    • Balance Sheet Summary: a summary of what you own (assets), what you owe (liabilities), and what you invested (equity).
    • Balance Sheet: what you own (assets), what you owe (liabilities), and what you invested (equity).
    • Custom Summary Report: a report you build from scratch. With more options to customise.
    • Profit and Loss as % of total income: your expenses as a percentage of your total income.
    • Profit and Loss Comparison: your income, expenses, and net income (profit or loss) compared to last year.
    • Profit and Loss Detail: profit and Loss Detail
    • Monthly Profit and Loss: Your income, expenses, and net income (profit or loss). Statistics by month.
    • Profit and Loss: your income, expenses, and net income (profit or loss). Also called an income statement.
    • Statement of Cash Flows: cash flowing in and out from sales and expenses (operating activities), investments, and financing.
    • Statement of Changes in Equity: statement of changes in equity.
15. Bookkeeping Reports:
    • Account list: the name, type, and balance for each account in your chart of accounts.
    • Balance Sheet Comparison: what you own (assets), what you owe (liabilities), and what you invested (equity) compared to last year.
    • Balance Sheet: what you own (assets), what you owe (liabilities), and what you invested (equity).
    • General Ledger: the beginning balance, transactions, and total for each account in your chart of accounts.
    • Journal: the debits and credits for each transaction, listed by date.
    • Profit and Loss Comparison: your income, expenses, and net income (profit or loss) compared to last year.
    • Profit and Loss: your income, expenses, and net income (profit or loss). Also called an income statement.
    • Account history: account history
    • Recent Transactions: Transactions you created or edited in the last 4 days.
    • Statement of Cash Flows: cash flowing in and out from sales and expenses (operating activities), investments, and financing.
    • Transaction Detail by Account: transactions and total for each account in your chart of accounts.
    • Transaction List by Date: A list of all your transactions, ordered by date.
    • Trial Balance: this report summarises the debit and credit balances of each account on your chart of accounts during a period of time.
    • Reconciliation Summary: It will show your beginning and ending balances, as well as a list of which transactions were cleared and which were left uncleared when you reconciled.
    • Reconciliation Detail
16. Sales Tax Reports:
    • Tax Detail Report: This report lists the transactions that are included in each box on the tax return. The report is based on accrual accounting unless you changed your tax reporting preference to cash basis.
    • Tax Liability Report: How much sales tax you’ve collected and how much you owe to tax agencies.
    • Tax Summary Report: This report shows you the summary information for each box of the tax return. The report is based on accrual accounting unless you changed your tax reporting preference to cash basis.
17. Sales and Customers Reports:
    • Deposit Detail: your deposits, with the date, customer or supplier, and amount.
    • Income by Customer Summary: your income minus your expenses (net income) for each customer.
18. Expenses and Suppliers Reports:
    • Cheque Detail: The checks you’ve written, with the date, payee, and amount.
19. Budgets Reports:
    • Budget overview: this report summarises your budgeted account balances.
    • Profit and Loss Budget vs Actual: this report shows how well you are meeting your budget. For each type of account, the report compares your budgeted amounts to your actual amounts.
    • Profit and loss budget performance: this report compares actual amounts to budgeted amounts for the month, the fiscal year to date, and the annual budget.
20. A/R Reports:
    • Accounts Receivable Aging Summary: unpaid balances for each customer, grouped by days past due.
    • Accounts Receivable Aging Detail: unpaid invoices, grouped by days past due.
21. A/P Reports:
    • Accounts Payable Aging Summary: the total amount of your unpaid bills, grouped by days past due.
    • Accounts Payable Aging Detail: your unpaid bills, grouped by days past due.
22. Settings:
    • General
    • Account Detail Types
    • Plaid Environment Setup
    • Income Statement Modification
    • Currency Rates

Demo

Accounting & Bookkeeping module Demo

Set-up

Included documentation will help you upload and activate the module inside Perfex CRM, if you are not aware on how to do it.

Support

Our support team is always around to help. Feel free to raise a support ticket.
Guys from support department will get back to you as soon as possible with a reply, guiding you through any issues.

Changelog

Version 1.0.0 / 2021-04-08

    Initial version

Version 1.0.1 / 2021-04-17

    Multi-currency support.
    Add the feature to filter data by fiscal year.
    Add expense category mapping feature.
    Add a feature to set up automatic mapping for invoices, payments, expenses and taxes.
    Add sales tax reports: tax detail report, tax liability report and tax summary report.
    Add bulk delete/activate/deactivate the feature for a chart of accounts.

Version 1.0.3 / 2021-05-17

    Add accrual accounting method.
    Add feature to enable/disable default mappings for transaction types.
    Add parent accounting account feature.
    Add tree chart of accounts feature.
    Add feature to create your own account detailed type
    Upgrade accounting reports

Version 1.0.5 / 2021-05-22

    Fix minor bugs.
    Add feature to set priority expense mapping by category or by payment mode.
    Update mapping transactions for payment, invoice, and expense.
    Update reports.

Version 1.0.8 / 2021-08-25

    Integration with modules: Purchase Management, Inventory Management, and HR Payroll.
    Add budgets management.
    Add budget overview.
    Add profit and loss budget vs actual.
    Add profit and loss budget performance.
    Add accounts receivable aging summary.
    Add accounts receivable aging detail.
    Add accounts payable aging summary.
    Add accounts payable aging detail.

Version 1.1.2 / 2022-04-21

    Fix minor bugs.
    Remove mapping when deleting: purchase order, purchase invoice, payslip, stock export, stock import, loss adjustment.
    Update reports: accounts receivable aging detail, accounts receivable aging summary.
    Update opening balance can be negative.
    Upgrade automatic double-entry rules for Purchase Management and Inventory Management modules.    
    Support RTL.
    Add double entry for credit note, discount.    
    Add budget import function.
    Add account import function.    
    Add Plaid API settings to connect with banks.
    Add bank register feature.
    Add posted bank transactions feature.
    Add reconcile bank accounts feature.
    Add bank reconciliation summary report.
    Add bank reconciliation detail.

Version 1.1.3 / 2022-05-21

    Fix minor bugs.
    Update reports related to budget, business overview.

Version 1.1.4 / 2022-05-25

    Fix minor bugs.    

Version 1.1.5 / 2022-06-07

    Update hooks of payment feature for Perfex CRM version 2.9.4    

Version 1.1.6 / 2022-06-21

    [Updated] Update import budget feature (year, quarter, month) from excel file.    
    [Updated] Update budget management features and budget reports by fiscal year.

Version 1.1.8 / 2024-05-22

    Allow credit note mapping
    Add Registers function
    Update banking: Separate Bank Account to manage a separate menu, allow Bank Account to connect to Plaid API, and add Bank reconcile function.

Version 1.1.9 / 2024-05-22

    Fix error of importing bank transactions with the wrong date
    Fix expense error not automatically mapping to the release side
    Fix multi-currency error when mapping purchase
    Fix incorrect filter errors of lists in the banking menu
    Fix the error of displaying incorrect currency when mapping purchase orders
    Fix error Report accounts payable aging summary, accounts payable aging detail displays both vendor and customer
    Fix the error of delivery notes from Omni sale orders not being automatically mapped
    Fix the error of the delivery note for Manufacturing order production not being automatically mapped
    Fix the error of warehouse receipt generated from manufacturing not being mapped automatically

Version 1.2.0 / 2024-05-22

    Fix an error when creating Expense category mapping setup; the default "Preferred the payment method" field is selected but "Preferred the payment method" is still displayed as inactive
    Fix import bank transaction by Excel error: The payee field is a required field but still imported successfully when it is left blank
    Fix Bill-Unpaid Bills error: Edit bill icon is not displayed. Fix error when printing check
    Fix errors related to credit note mapping into accounting
    Successfully fixed the Verify bank account error but it is still not authenticated
    Fix the error of deleting expenses, but their value is still displayed in the report
    Update the mapping of the delivery note: The product in the delivery note displays the selling price, so when mapping, you must map two types of inventory accounts and profit accounts.
    Optimize profit and loss detail reports

Version 1.2.1 / 2024-05-22

    Fix the error of not displaying the currency exchange rate editing icon in transactions
    Add a hyperlink to transaction details in the report

Version 1.2.2 / 2024-05-22

    Updated filter for balance sheet report: filter 1 date field and filter 2 date fields. As for the balance sheet detail report, it filters 2 date fields and loads the beginning balance
    Fix the error of deleting payment but still displaying it in the report

Version 1.2.3 / 2024-05-22

    Allows Edit and delete transactions imported into banking or received directly from banking

Version 1.2.4 / 2024-05-22

    Separate the Bank type from Cash and Cash

Version 1.2.5 / 2024-05-22

    Add the Income Statement Modification function and apply it to P&L reports

Version 1.2.6 / 2024-05-22

    Additional processing of opening balances for customers and vendors
    Added Accounts Payable Aging report to record Bill
    Add filter by customer and customer group for Accounts Receivable Ageing Detail and Accounts Receivable Ageing Summary

Version 1.2.7 / 2024-05-22

    Update tax mapping by discount type (before tax and after-tax) for Sale invoice and Purchase
    Added tax mapping of sales invoice
    Fix the error of Account Payable Aging report not deducting the paid portion
    Fix error where expense mapping cannot be converted from PO
    Fix error of not being able to get transactions from the Plaid API
    Fix error of not getting a description when getting transactions from the Plaid API

Version 1.2.8 / 2024-05-22

    Updated banking rule, added mapping type (full amount, split by percentage, and split by amount)

Version 1.2.9 / 2024-05-22

    Fix the error of not displaying the sample file in the import screen (Ported Bank transactions screen).
    Fix the error of the delivery note not being automatically mapped (this delivery note is automatically created after creating the invoice and is created manually in the order details).
    Fix the reset data function error: Cannot create a bank account, so delete the account details type.
    Fix error of not being able to view the Balance sheet detail report and Deposit detail report when there are sub-accounts.
    Fix the error of not being able to load the chart of account list.
    Fix error of not being able to update the account and bank account.
    Fix the error of automatically mapping expenses incorrectly.
    Fix the error where credit notes have been deleted but are still displayed in reports.
    Display 0% tax in the Tax Detail report.
    Allow the "All Time" filter for reports outside the dashboard.
    Chart of account – Add function to sort by type and detail type.

Version 1.3.0 / 2024-05-22

    Added mapping settings for warehouse receipts created from return orders
    Add a button to active/inactive profit mapping of warehouse delivery notes, to turn profit mapping on and off
    Fix incorrect mapping of the value of the warehouse receipt from the return order
    Upgrade source code to be compatible with PHP 8.1.
    Upgraded features to be compatible with the latest version of Perfex CRM.

Version 1.3.1 / 2024-08-15

    Fixed the issue of loading the journal entry list.
    Plaid API: Fixed an issue related to verifying the bank account.
    Added Currency rate settings, and all transactions are converted according to the rate taken from settings.
    Optimized data loading time in the Transactions menu.

Version 1.3.2 / 2024-08-15

    Updated Journal Entry interface.
    Updated Purchase Invoice mapping, only mapping Purchase Invoices with Approved status.
    Added Recurring Journal Entry function.
    Import bank statement feature allows Import csv file.

Version 1.3.3 / 2024-08-15

    Added permissions to the Register menu.
    Chart of Account: The Balance column of Parent accounts will also count the Balance from child accounts.
    Fixed the issue related to entering "0" in the Balance field also recording the Opening balance for the bank account.
    Fixed the issue related to not being able to delete transactions in the Register function.
    Fixed the issue related to filtering transactions in the Register.

Version 1.3.4 / 2024-08-15

    Updated A/R, A/P, Reconciliation reports.
    Updated Bill Management, Checks Management features.
    Added Items section in Bill feature.
    Added Pay Bill management feature.
    Added Bank Feeds feature.