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
- Dashboard: Profit & Loss Chart, Income Chart, Expense Chart, Cashflow Chart and Bank Accounts Overview
-
Banking:
- Bank Accounts
- Banking Register
- Posted Bank Transaction
- Setups Your Bank Account
- Reconcile Bank Account
-
Transactions:
- 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)
- Bills Management
- Register is where you quickly enter money you have received from your customers and payments you have made to your suppliers or vendors
- Banking Rules: to automatically categorize transactions
- Journal Entry: to record transactions in the general ledger
- Transfer: to transfers of amounts between accounts
- 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).
- Reconcile: is the process of matching transactions entered into module against your bank or credit card statements
- 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
-
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
-
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
- Profit and Loss year-to-date comparison: your income, expenses, and net income (profit or loss) compared to this year so far.
- 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.
-
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.
-
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.
-
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.
-
Expenses and Suppliers Reports:
- Cheque Detail: The checks you’ve written, with the date, payee, and amount.
-
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.
-
Accounts Aging 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.
- 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.
-
Banking Reports:
- Bank Reconciliation Summary
- Bank Reconciliation Detail
-
Settings:
- General
- Account Detail Types Management
- Plaid Environment Setup
- Income Statement Modification
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-08Initial versionVersion 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 reportsVersion 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.4Version 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 automaticallyVersion 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 reportsVersion 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 reportVersion 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 reportVersion 1.2.3 / 2024-05-22
Allows Edit and delete transactions imported into banking or received directly from bankingVersion 1.2.4 / 2024-05-22
Separate the Bank type from Cash and CashVersion 1.2.5 / 2024-05-22
Add the Income Statement Modification function and apply it to P&L reportsVersion 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 SummaryVersion 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 APIVersion 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.