Accounting and Bookkeeping module for Perfex CRM

Description

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 Management Banking Feeds Download Transactions Import Transactions Add Edit Delete Transactions Match Ignore Transactions Verify Account 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 Bills Management Checks 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 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 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 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 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 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 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