Finance

Masters & Setup Company in Finance Module
Voucher Entry
Voucher Staging Entries
Integration Staging
Monthly Reports
Customer Reports
Supplier Reports
Tax Reports

Masters & Setup Company in Finance Module

cuteOffice finance module helps accounts team to manage all activities related to the corporate finance effectively.

The key functionalities of the finance module are:

Masters
Voucher Entry
Voucher Staging Entries
Integration Staging
Monthly Reports
Customer Reports
Supplier Reports
Tax Reports
Link Account Setup

Finance module greatly helps to manage financial data. The subsequent reports can be generated automatically without any manual intervention.

Click Finance tab in cuteOffice system, below is the screenshot of finance module home page.

Finance Module Prerequisites

The following set of information is required for the implementation of the Finance Module. The information could be provided in the form of Excel for upload to the system.

Setup a financial year

Before start using the finance module, the company needs to be configured for a financial year so that the users can start to use the system. The administrator of cuteOffice can configure the financial year details of the company in Admin menu-Company submenu.

Click Company in the Admin menu, the admin companies (holding companies or any affiliate companies registered in system will show,
Select the company and click edit button to open the company detail page as below,
Navigate to the Finance tab. Note: When there is no financial year setup currently, the list shows no record.
To add a new financial year, Click to create a new financial year. The Add Financial Year window opens,
Enter the start date, end date and freeze date of the financial year. Note: With this Freeze date setup, end users will not be able to do any transaction before this specified date.
Click Save. The financial year data will be saved.

Letterhead Upload

To view letter head in the sales invoice report, the below setting has to configured.

Go to Admin and Click Company
Click Logo Upload. Choose Letter Pad in the image type.
Click choose file and upload the company letter head.
Go to company settings and click add
Enter the name as " financeSalesInvoiceReportFormat".
Enter the value as "SALESINVOICEFORMAT3"
Click save to save the settings
Click add and enter name as " financeSalesInvoiceReportStartPosition"
Enter value starting from 20 to adjust the Invoice header in the report
Click save to save the position of the "Invoice"

Chart of Accounts

This file will represent the Chart of Accounts that would be used in the Finance Module. The file would also contain the Opening Balance that needs to be considered for the individual Account lines.

Fields Required

Account Name : Name of the Account

Account Number : Account Number in Numeric

Opening Balance : Account Opening Balance

Account Type : Asset / Liability / Equity / Income / Expense / Other Income / Other Expense / Cost Of Sales

Account Sub Type : Fixed Asset / Current Asset / Current Liability / Income / Expense / Other Income / Other Expense

/ Cost Of Sales

Level : 1 - ASSET ,2 – Fixed Asset , 3 – Cash At Bank , 4 – Cheque Account

Type : Header / Detail (Ex: ASSET ->Fixed Asset – Header, Cheque Account - Detail)

Parent Account : Asset -> Fixed Asset - > Cash At Bank -> Cheque Account (Child Account))

Customer Master

The file is to represent the list of Customers. The Customer Number will be generated by the Finance module

Fields Required

Customer Name : Name of the Customer

Country : Country where the customer belongs to Ex: Singapore / Australia / Malaysia etc..

Customer Type : Agent / Client / Sub Contractor etc..

Industry Type : IT / Automobile / Construction etc..

Sub Industry Type : Software / Medical / Cement Companies etc..

Currency : SGD / USD / AUD etc..

GST Number : Customer Registration Number

Payment Mode : Cheque / TT / Cash

Fax : Country Code – Area Code – Telephone Number

Website : Website URL of the customer

eMail : Customer eMail

Contact No : Country Code – Area Code – Telephone Number

Address : Customer Address

Customer Receivables

This file would contain the Opening Balances of all Customer Invoices. As a control measure the sum of all the outstanding invoices should match with the Debtors Opening Balance provided as part of Chart of Accounts. If the Customer Balances are maintained at a multi-currency level, then the outstanding invoices should be the multi-currency level with the Balances tallying.

Fields Required

Invoice Number : Invoice Transaction ID

Invoice Date : Invoice Transaction Date

Customer Name : Name of the Customer (as provided in the Customer Master)

Currency : SGD / USD / AUD etc..

Tax Code : TX – 7, SR – 7, NT – 0 etc

Invoice Amount : Gross Total of the Invoice

Terms : 7 Days / 30 Days / COD etc

Memo : Invoice Description

Supplier Master

The file is to represent the list of Suppliers. The Supplier Number will be generated by the Finance module.

Fields Required

Supplier Name : Name of the Supplier

Country : Country where the Supplier belongs to Ex: Singapore / Australia / Malaysia etc..

Supplier Type : Agent / Client / Sub Contractor etc..

Industry Type : IT / Automobile / Construction etc..

Sub Industry Type : Software / Medical / Cement Companies etc..

Currency : SGD / USD / AUD etc..

GST Number : Supplier Registration Number

Payment Mode : Cheque / TT / Cash

Fax : Country Code – Area Code – Telephone Number

Website : Website URL of the customer

eMail : Supplier eMail

Contact No : Country Code – Area Code – Telephone Number

Address : Supplier Address

Supplier Payables

This file would contain the Opening Balances of all Supplier Purchase Invoices. As a control measure the sum of all the outstanding purchase invoices should match with the Creditors Opening Balance provided as part of Chart of Accounts. If the Supplier Balances are maintained at a multi-currency level, then the outstanding invoices should be the multi-currency level with the Balances tallying.

Fields Required

Invoice Number : Invoice Transaction ID

Invoice Date : Invoice Transaction Date

Supplier Name : Name of the Supplier (as provided in the Supplier Master)

Currency : SGD / USD / AUD etc..

Tax Code : TX – 7, SR – 7, NT – 0 etc

Invoice Amount : Gross Total of the Invoice

Terms : 7 Days / 30 Days / COD etc

Memo : Invoice Description

Tax Codes

This file is required to store the Tax Codes in the System.

Fields Required

Tax Code : TX – 7, SR – 7, NT – 0 etc.

Tax Type : Goods & Service Tax

Tax Description : Description of the Tax, Standard Rate etc..

Percentage : 7 %

Terms : 7 Days / 30 Days / COD etc

Form Type : Sales / Purchase

Exchange Rate (For Foreign Currency Transactions)

This file is required to store the Exchange Rate difference between the foreign currency & Base Currency in the System.

Fields Required

Base Currency : SGD

Foreign Currency : Foreign Currency Code

Rate : Exchange Rate

Sales Linked Accounts

The following configuration parameters needs to be provided to setup the Finance module which are required for Sales related transactions. Client needs to provide the Account Number (from the Chart of Accounts provided) which would be configured in the application.

Asset Account for Tracking Receivable : Debtors Account

Bank Account for Customer Receipts : Primary Bank Account

Accounts for Goods & Service Tax : GST Receiving Account

Income Account for Freight : Freight Account

Contra Account : Contra Adjustment Sales Account

Customer Pre-payments : Pre-payment Customer Account

Income Account for Late Charges : Late Charges Collection Account

Foreign Currency Customer Account : Foreign Currency Customer Debtor Account. Ex for USD Currency Customer Account, use Trade Debtors – USD Account

Foreign Currency Exchange Difference : Foreign Currency Exchange Difference Account Customer Debtor Ex for USD Exchange difference, use Trade Debtors Foreign Exchange – USD Account

Purchase Linked Accounts

The following configuration parameters needs to be provided to setup the Finance module which are required for Purchase related transactions. Client needs to provide the Account Number (from the Chart of Accounts provided) which would be configured in the application.

Liability Account for Tracking Payable : Creditors Account

Bank Account for Paying Bills : Primary Bank Account

Accounts for Goods & Service Tax : GST Paying Account

Contra Account : Contra Adjustment Purchase Account

Expense Account for Late Charges : Late Charges Payment Account

Foreign Currency Supplier Account : Foreign Currency Supplier Creditor Account. Ex for USD Currency Customer Account, use Trade Creditors – USD Account

Foreign Currency Exchange Difference : Foreign Currency Exchange Difference Account Supplier Creditor Ex for USD Exchange difference, use Trade Creditors Foreign Exchange – USD Account

Accounts & Banking Linked Accounts

The following configuration parameters needs to be provided to setup the Finance module

Equity Account for Current Earnings : Current Year Earning Account

Equity Account for Retained Earnings : Retained Earnings Account

Equity Account for Historical Balancing : Historical Balancing Account

Account for Currency Gain / Loss : Foreign Currency Gain / Loss Account

Master Data

Master Data in Finance module includes below data sets. Below are steps to add prerequisite data for finance module to run smoothly.

Chart of Accounts

The Chart of Accounts menu in the Finance is used to manage the chart of accounts.

A chart of accounts (COA) is a financial, organizational tool that provides an index of every account in an accounting system. This provides an insight into all the financial transactions of the company. Here, an account is a unique record for each type of asset, liability, equity, revenue and expense.

The chart of accounts is classified into eight major categories and stored in the company’s ledger. Each account in the chart of accounts is typically assigned a name and a unique number by which it can be identified.

Accounts Code	Classification	Accounts Type	Remarks
10000	Asset	Account Receivables Bank Assets (Current, Fixed, Others)	Cash, Accounts, Receivable, Land, Equipment
20000	Liability	Accounts Payable Credit Card Liability (Current, Long Term, Others)	Loans payable, Account payable
30000	Equity	Equity	Paid up capital
40000	Income	Income	Revenue from sales
50000	Cost of Sales	Cost of Sales	Purchases
60000	Expense	Expense	Other expenses of business
80000	Other Income	Other Income	Non-operating revenues and gains
90000	Other Expense	Other Expense	Non-operating expenses and losses

The chart of accounts lists the accounts that are available for recording transactions. In keeping with the double-entry system of accounting, a minimum of two accounts is needed for every transaction- at least one account is debited and at least one account is credited.
Some general rules about debiting and crediting the accounts are:

Asset accounts normally have debit balances

To increase an asset account, debit the account
To decrease an asset account, credit the account

Liability accounts normally have credit balances

To increase a liability account, credit the account
To decrease a liability account, debit the account

View Chart of Accounts

To navigate to Chart of Accounts, Click Chart of Accounts in the Finance The Chart of Accounts page opens.

Add a New Account Code

You can add the accounts only in the starting of the financial year. In the middle of the financial year, you cannot add or change any account.

To add a new account code,

Click(Add New button) in the upper right-corner of the Chart of Accounts list page, the Add Account Code window opens,
Select the type of account code whether it's Header or Detail.
Header - Header is used only for grouping. Transactions cannot be posted under this code.

Detail – All transactions can be posted under the detail account code.
If the account to be created is inactive account, enable the Inactive Account
In the Parent Account box, select parent account name.
In the Account Type box, the account type will automatically populated when parent account is selected.
In the Currency box, select the currency.
In the Account Sub Type box, select the account sub type.
In the Account Number box, enter the account number.
In the Account Name box, enter the name of the account.
In the Opening Balance box, enter the opening balance of the account.
In the Current Balance box, for new account it will default showing 0.
Click Save. The new account code will be created and listed in the Chart of Accounts page.

Edit Account Code

If you want to edit any added account code in the Chart of Accounts page, do the following page,

Click (Edit icon) of the Account Code and Name which you want to edit, the edit account code page opens,
Click any box where you want to edit the account details, and then edit the details in the respective box in the Edit Account Code
Click Save to save edits.

Export Chart of Accounts

User can use the print or export option to print or export the chart of accounts.

Customers

Customers master manages all customer's company details so that sales activities and transactions can be recorded and entered in finance module.

To view all customers, click Customers submenu in Master menu,

Add A New Customer

To add a new customer,

click (add button) in the upper right corner of customer list page, the customer detail page open,
Enter customer details in above page.
Click Save. The new customer master data is created and saved in system.

Edit Customer

To edit customer data,

Delete Customer

If a customer is not yet in any transaction in system, user can use delete option to delete customer data,

click the (delete button) in the delete column of the customer that user wants to delete, a confirmation window opens,
Click Yes to confirm deletion. Note: if a customer is already in use/transaction, below error message will pop up in the bottom right corner and system will not allow deletion.

Export Customer

User can use the export option to export customer data. Select and click the format that user want to download.

Suppliers

Suppliers master manages all suppliers' company details so that purchase activities and transactions can be recorded and entered in finance module.

To view all suppliers, click Suppliers submenu in Master menu,

Add A New Supplier

To add a new supplier,

Click add button in the upper right corner of the suppliers list page, the supplier detail page opens,
Enter all details of the new supplier.
Click Save. The new supplier master data is created and saved in system.

Edit Supplier

To edit supplier data,

Click(edit button) in the edit column of the supplier that user wants to edit, the supplier detail page opens,
Edit the fields where needed.
Click Save to save edits.

Delete Supplier

If a supplier is not yet in any transaction in system, user can use delete option to delete supplier data,

click the (delete button) in the delete column of the supplier that user wants to delete, a confirmation window opens,
Click Yes to confirm deletion. Note: if a supplier is already in use/transaction, below error message will pop up in the bottom right corner and system will not allow deletion.

Export Supplier

User can use the export option to export supplier data. Select and click the format that user want to download.

Bank details

The Bank Details tab in the Finance menu used to manage all the bank account details of the company. The Bank Details data will be automatically synchronized is integrated with the Sales Register and Purchase Register pages.

To view all bank details, click Bank Detail in the Master menu, the bank details list open,

Add A New Bank

To add a new bank,

Click (Add button) in the upper right-corner of the bank detail list page. The Bank Details Add/Edit window opens.
Enter the bank details in the relevant fields.
Click Save. The bank account is added and saved in the Bank Details list page.

Edit Bank Account Details

To edit any added bank account details in the Bank Details page,

Click (Edit icon) in the Edit column for the respective bank account. The Bank Details Add/Edit window opens.

Click and edit any fields where user wants to edit the details
Click Save to save edits.

Delete A Bank Account Details

If a bank account is not yet in use, user can delete if needed. To delete,

click the (delete button) in the delete column of the bank account that user wants to delete, a confirmation window opens,
Click Yes to confirm deletion. Note: if a bank account is already in use/transaction, below error message will pop up in the bottom right corner and system will not allow deletion.

Card Entries

Card entries helps to manage company bank cards details. Click Card Entries in the Master menu, all the bank cards saved in system will show as below,

Add A New Card

To add a new card,

Click (Add button) in the upper right-corner of the card detail list page. The Card Entry window opens,
Enter the card details.
Click Save to save card entry. Card details will be saved and shown in the card entry list page.

Edit Card Details

To edit any added card details in the Card Entries page,

Click (Edit icon) in the Edit column for the respective card detail. The Card Enrty window opens.

Click and edit any fields where user wants to edit the details
Click Save to save edits.

Delete A Card

If a card is not yet in transaction record in system, user can delete if needed. To delete a card detail,

click the (delete button) in the delete column of the card number that user wants to delete, a confirmation window opens,
Click Yes to confirm deletion.

Direct Payee

Each and every direct payee’s detail needs to be added before any of the transactions such as purchase details can be entered. Before adding a direct payee, the respective users must be assigned with the Payee permission. To assign permission,

Navigate to Admin>>Users.
Select the respective user and navigate to Permission.
Enable the permission of Payee.
Click Save. User will be able to add a direct payee.

Add A Direct Payee

To add a direct payee,

Navigate to Master, click Direct Payee. The Direct Payee page opens as below,
Click (Add button) in the top right corner. The Direct Payee window opens,
Enter the direct payee details.
Click Save. The direct payee will be added in the Direct Payee page. The added payee will be listed in the Pay Bills Entry page by selecting the PAYMENT VOUCHER option while adding the pay bill details.

Edit Direct Payee

To edit direct payee details,

Click (Edit icon) in the Edit column for the respective direct payee. The direct payee details window opens.

Click and edit any fields where user wants to edit the details
Click Save to save edits.

Delete A Direct Payee

If a direct payee is not yet in transaction record in system, user can delete if needed. To delete a card detail,

click the (delete button) in the delete column of the direct payee that user wants to delete, a confirmation window opens,
Click Yes to confirm deletion.

Direct Payor

Each and every direct payor’s detail needs to be added before any of the transactions such as sales can be entered. Before adding a direct payor, the respective users must be assigned with the Payor permission. To assign permission,

Navigate to Admin>> Users
Select the respective user and navigate to Permission.
Enable the permission of Payor.
Click Save. User will be able to add a direct payor.

Add A Direct Payor

To add a direct payor,

Navigate to Master, click Direct Payor. The Direct Payor page opens.
Click (Add button) in the top right corner. The Direct Payor window opens.
Enter the direct payor details.
Click Save. The direct payor will be added in the Direct Payor page. The added payer will be listed in the Receive Payment Entry page by selecting the RECEIPT VOUCHER option while adding the payment details.

Edit Direct Payor

To edit direct payor details,

Click (Edit icon) in the Edit column for the respective direct payee. The direct payor details window opens.

Click and edit any fields where user wants to edit the details
Click Save to save edits.

Delete A Direct Payor

If a direct payor is not yet in transaction record in system, user can delete if needed. To delete a card detail,

click the (delete button) in the delete column of the direct payor that user wants to delete, a confirmation window opens,
Click Yes to confirm deletion.

Tax

Tax type, and percentage are managed in Tax master. Click Tax in Master menu, below list of tax master opens,

Add Tax Type

To add a new tax type master,

Click add button in the top right corner in the tax master list page, the new tax detail page opens,
Fill up the details of the tax master:
- In Tax Type box, enter tax type.
- In Tax Code box, enter the code.
- In Description box, enter description of the tax type.
- In Percentage box, enter the percentage between 0-100.
- In Form Type box, select the form type.
Click Save. A new tax type is created and saved in the tax master.

Edit Tax Type

To edit a tax type master,

Clickedit button in front of the tax type that needs to be edited. The tax type details window opens,
Edit the details where suits.
Click Save to save edits.

Delete Tax Type

To delete a tax type master,

Clickdelete button in the delete column in the relevant tax type. A confirmation window will open as below,
Click Yes to confirm deletion. The tax type will be deleted.

Invoice Number Configure

User can configure the invoice format and invoice number in Master-Invoice Number Config.

To configure invoice number,

Click Invoice Number Config in the finance master menu, below configure page opens,
Enter the details to configure:
- In Prefix box, if there is no prefix required, disable the flag to No; if there is prefix, enable the flag to Yes, then enter the prefix in the text field.
- In Month box, if there is no month info required, disable the flag to No; if there is, enable the flag to Yes, then enter the month format in the text field.
- In Year box, if there is year info required, disable the flag to No; if there is, enable the flag to Yes, then enter the year format in the text field.
- In Running Sequence, enter the first running number
- In Divider box, enter the divider if any
Click Save to save configuration details.

Exchange Rate

The exchange rate used in finance module are managed in exchange rate master. Click Exchange Rate in master menu, below exchange rate list opens,

Note: Exchange rate fluctuate due to various factors, cuteOffice exchange rate master accommodate such changes in exchange rate. If an exchange rate is created for the first time in the system, the "to date" field will be open so it’s definite the "to date" is as of now; when a new rate is added or edited on existing exchange rate, the adding or editing date will become the "to date" of the previous rate, as such, exchange rate can be within a period which is defined as from date & to date. Whenever finance vouchers are entered for foreign exchange the rate is picked based on the voucher date

Add Exchange Rate

To add new exchange rate,

Click add button in the top right corner in exchange rate list page, the exchange rate add/edit window opens as below,
Enter the details of exchange rate:
- Base Currency box is default as SGD, this can be configured as other currency upon request.
- In Foreign currency box, select the foreign currency from dropdown list.
- In From Date box, the date will automatically take the end date of current active rate.
- In To Date box, if it's the first time to configure an exchange rate, this field will be open, no need to fill up.
- In Rate box, enter the exchange rate.
Click Save. A new exchange rate will be added.

Edit Exchange Rate

To edit exchange rate,

Clickedit button in front of the exchange rate, the exchange rate detail window opens,
In Rate box, enter the new exchange rate.
Click Save, a new exchange rate will be saved based on the current date and time.

Voucher Entry

Voucher Entry manages all finance transactions. It contains below submenu:

Sales Register
Receive Payments
Purchases Register
Pay Bills
Transactions Journal
Bank Register
Petty Cash Register
Transfer Money
Bank Reconciliation
Remittance Advices
Find Transactions
Item Transactions

Sales Register

Sales Register helps to record and manage the sales and income from sales. The list of transactions pertaining to each month can be viewed by selecting that month, customer, and transaction status. Click Sales Register in the Voucher Entry menu, The Sales Register page opens.

View Sales Entry

If you want to view the sales entry details of a particular customer, you can use the filters to search

In the Calendar field, select the period for which you want to view the sales entry details.
In the Customer box, select a customer.
In the Status box, select the status for you want to view the sales entry details.
Click . The sales entry detail opens for the selected customer and period.

Enable Permission for Sales Recurring Transaction

If you want to add a new sales entry by using the transaction details of an existing invoice number, you need to enable permission for accessing the Sales recurring transaction option. To enable the permission for sales recurring transaction, search for permission name "SalesRecurring" in user 's permission page and enable both read and write permissions. Once you have enabled this permission, the sale recurring transaction related option will be appeared while adding a new sales entry.

Add a New Sales Entry

To add a sales entry,

Click (Add icon) provided in the upper right-corner of the Sales Register page, the Sales Entry page opens as below,

Note: useful navigation options

(Journal button)-You can use the Journal option to view the sales journal entry. Sales journal entry records a cash or credit sale to a customer. Sales journal entries also reflect changes to accounts such as Cost of Goods Sold, Inventory, and Sales Tax Payable accounts.
(Payment button) – used to navigate into the Receive Payments Entry page.
(Register button) – used to navigate into the Sales Register page.

Add Sales Entry using Recurring Option

If you want to add a sales entry by using the sales recurring option,

Click (use recurring button), all the saved recurring transactions page will open as below,
Select an invoice number from the recurring transactions list. Click the use icon. Once the invoice number is selected, it will retrieve the respective transaction details saved successfully in cuteOffice. All the input fields will be automatically filled up according to the selection of invoice number.

Note: to save a sale entry as Recurring, enable the "Save As Recurring" flag to Yes when register a sales entry. Once saved as recurring entry, it will be shown in the recurring transaction page when use "Use Recurring" option to register sales entry.

Add Sales Entry Manually

To add a sales entry manually,

In the Sales Form Type field, select the sales form type you want to add.
If the tax is inclusive for the sales entry, enable Yes in the in the Tax Inclusive option.
In the Customer box, select a customer from customer dropdown list. Note: If you can't find the customer in the list, and want to add as a new customer, you can click the add button near the Customer box.
In the Terms box, select the terms. Terms refers to the payment period of the customer. For example, if you select the terms as COD, then the customer needs to pay cash on delivery. If you select 30 Days, then the customer needs to pay the amount within the 30 days of delivery.
In the Ship to box, select the shipping location. Note: once you have selected the shipping location, the shipping address will be automatically updated in the Address box.
In the Destination Country box, enter the destination country detail.
In the Invoice box, the invoice number will be updated automatically. Note: If you want to edit the invoice number, click (Edit button) and change the invoice number.
In the Customer Purchase Order (PO) box, enter the customer PO number.
In the Date box, select the date (click in the field and select from the calendar).
In the Bank Account box, select the bank account to receive payment from the customer.
In the Account Number/Name box, select the appropriate chart of account from the list of chart of accounts. Note: If you want to add additional account number, click (Add button) and add the account and item details by following the below steps. Once you have selected the account number and name, the Description box shows the description for the corresponding selected account.
In the Period of Work box, select the number of days spent for this work.
In the Units box, enter the number of items purchased by the customer.
In the Rate box, enter the rate of each item.
Once you have entered the units and rate of the item, the total amount will be calculated and displayed in the Amount box.
In the Project box, select for which project, the items are purchased.
In the Tax box, select a tax code from the given tax codes. The total amount for the items will be automatically updated in the Sub Total box. Tax Codes:
Zero Rated (ZR) – 0% GST– Export of goods to overseas.
Standard Rated (SR) -7% GST– Most local sales falls under this category.
Exempt Supplies (EX) - GST is not applicable – Sale of unfurnished residential property, Importation and local supply of investment precious metals.
In the Sales Person box, enter the name of the sales person.
In the Invoice Delivery Status box, select the invoice delivery status from the list.
In the Promised Date box, select the date when the item will be delivered.
In the Fright box, select the tax percentage for the freight charges.
The tax amount will be automatically updated in the Tax box.
Click Record to complete sales register.

Add/Change Exchange Rate (Need team's input re this section)

Make sure that you cannot edit the exchange rate of the base currency Singapore Dollar (SGD).

Once you have added the sales amount details, if you want to change the USD exchange rate, do the following steps,

Click (Rate button) provided in the Sales Entry, The Exchange Rate Add/Edit window opens.
In the Base Currency box, select the base currency.
In the Foreign Currency box, select the foreign currency.
In the Rate box, enter the exchange rate.
Click Save.

The exchange rate will be changed and the total amount will be calculated according to the selected exchange rate.

Send Invoice to Customers through Email

If you want to send the invoices to the specific customer,

Select the checkbox provided in the Send Emails column for the invoices which you want to send to the customer.
Click(E-Mail icon) provided in the Sales Register. The selected invoices will be sent to the respective email address.

Add Purchase Details Against a Sales Invoice (need team's input)

Edit the Sales Entry Details

If you want to edit any added sales entry details in the Sales Entry page, navigate to sales register list view page,

Click (Edit icon) in the Edit column for the respective sales entry. The Sales Entry page opens and shows the added sales details.
Click and edit where needed.
Click Record to save edits. The Changed sales entry details will be updated.

Delete Any Added Sales Entry

If you want to delete any added sales entry, you can use delete option provided in the Delete column of the Sales Register page,

Click (Delete icon) for the corresponding sales entry. You receive a notification message “Are you sure to delete a record?”
Click Yes. The selected sales entry will be deleted.

Print the Invoice Details

If you want to print the invoice details of the particular sales entry, click (Print icon) provided in the Print column for the corresponding sales entry.

Settings Configuration to Print Invoice

Click (Edit icon) in the Edit column for the respective company. The company page opens and go to settings tabs. Use filter and enter "financeSalesInvoiceReportFormat".
Click edit and enter "SALESINVOICEFORMAT3" in the value.
Click Save to save details.
Go to Logo upload tab and choose "Letter Pad" in the image type.
Click choose file and add Company Letterhead.
Click Show Preview and Save the details.

Note : Use setting "financeSalesInvoiceReportStartPosition" to adjust the space between header and "Tax Invoice" in the report

Export the Sales Register

If you want to export the added sales entries in the Sales Register page in the excel format, you can click (Excel icon). The added sales entries will be downloaded in the excel format.

Receive Payments

The Receive Payments tab in the Finance menu helps you to add the details of the payment received from the customer. Click Receive Payments in the Finance, the Receive Payments Register page opens as below,

View Received Payments

If you want to view the received payment entry details of the particular bank account, you can use below filter to search,

In the Calendar field, select the period for which you want to view the received payment entry details.
In the Account box, select a bank account.
Click , the received payment entry detail opens for the selected bank account and period.

Add a Received Payment Entry

To add a received payment details,

Click(Add icon) provided in the upper right-corner of the Receive Payments Register. The Receive Payments Entry page opens.
In the Receipt Type field, if you want to add the details of payment received from any buyer other than the customers, select the RECEIPT VOUCHER, Once you select the RECEIPT VOUCHER option, the Receive Payments Entry page shows the following fields to be filled.
- In the Bank Account box, select a bank account.
- In the Payor box, select a payor from a drop-down list.
- In the Address box, enter the address of the person or company who has made payment.
- In the Date box, select the date of payment.
- In the Payment Method box, select the mode of payment.
- In the Currency box, select the currency type.
- In the Account Name/Number box, select any one of appropriate chart of account from the list of charts of accounts.
  - If you want to add additional account number, click (Add button) and add the account details.
  - If you want to add a new account number, click (Add New Account Number button) and add the account details.

Note: Once you have selected the account number and name, the Invoice Date box shows the invoice date and the Description box shows the description for the corresponding selected account.

In the Tax box, select a tax code from the given tax codes.
In the Amount applied box, enter the amount. Once you have selected the tax code and entered the amount, the GST and gross total will be automatically updated. The gain/loss amount will be automatically updated in the Gain/Loss box.
Click Record to save the received payments details. The added payment details will be saved and listed in the Receive Payments Register page. Note: If you want to print the received payments details, click (Record and Print button).

In the Receipt Type field, if you want to add the details of payment received from any customers, select the CUSTOMER. Once you select the CUSTOMER option, the Receive Payments Entry page shows the following fields to be filled.
- In the Deposit to Account box, select the amount deposit account.
- In the Customer box, select a customer from the list of customers. Once you have selected the customer, the list of invoices created for the respective customer open.
- In the Amount Received box, enter the received amount from the customer.
- In the Date box, select the date of payment.
- In the Payment Method box, select the mode of payment.
  - If you want to add any credit note or credit memo, select the Apply Credit Note. Credit Note is a way of refunding an invoice that has already been issued or paid. It can be for part of or the whole amount of an invoice. Once select Apply Credit Note option, the Credit Note fields will be displayed as below,
  - If you want to receive the payment from any overpayments, Select the Apply Overpayments option.
    
    Overpayment is a liability as it consists of money due back to the customer. Scenario 1 - Customer may pay an advance payment and park that amount for later adjusting against the invoice. Scenario 2 - Customer may pay extra amount and park that amount for later use. Once select Apply Overpayments option, the overpayment Confirm dialog box opens and shows the following notification,
    
    Click Yes. The Over Payments fields will be displayed as below:
    
    The system will display the information of over payment if available. The Amount box in the Over Payments field shows the balance amount of the over payment. If you want to receive the amount from the customer’s over payment, enter the amount in the Amount Applied box in the Over Payments field. The total amount will be adjusted from the applied over payment amount.
    
    Note: If you want to attach any file regarding credit note or overpayments, click (Choose Files button) and attach the file.
  - In the Invoices field, enter the discount amount in the Discount box.
    
    Note: To manually enter the amount in the Invoices field, the respective users must be assigned with the Manual Amount Filling permission.
If you want to enter the amount manually,
- In the Amount Applied box, enter the paid amount. Once you have entered the paid amount, the total applied, finance charge, total received and out of balance will be automatically updated. The gain/loss amount will be automatically updated in the Gain/Loss box.
- If you want to view the closed sales details, enable Yes in the View Closed Sales
- If you want to view all the payment details, click (Receive All button).
- Click Record to save the received payments details. The added payment details will be saved and listed in the Receive Payments Register page. Note: If you want to print the received payments details, click (Record and Print button).

Receive USD customer payment in SDD account.

If a customer is invoiced in USD and received payment in SGD, then use the below method to update the receive payment in system.

Example: Customer AlMansoori was invoiced with 7058 USD. The payment received in SGD account is SGD 9076.95

So the exchange rate calculated in 9076.95 / 7058 = 1.286051

Go to Receive payment entry screen and enter the USD amount in amount received textbox.

Click on Rate: USD and enter the exchange rate

Now Record the receipt.

The journal shows the actual receipt of 9076.95 in the SGD account as required.

Edit the Receive Payment Entry Details

If you want to edit any added receive payment entry details in the Receive Payments Entry page, do the following steps,

Click (Edit icon) in the Edit column for the respective receive payment entry. The Receive Payments Entry page opens and shows the added received payment details.
Click any box where you want to edit the details, and then edit the details in the respective box in the window.
Click Record. The changed receive payment entry details will be updated.

Delete Any Added Receive Payment Entry

If you want to delete any added receive payment entry, you can use (Delete icon) provided in the Delete column of the Receive Payments Register page,

Click (Delete icon) for the corresponding receive payments entry. You receive a notification message “Are you sure to delete a record?”.
Click Yes. The selected receive payments entry will be deleted.

Print the Receipt Voucher

If you want to print the receipt voucher of the particular received payment entry, click (Print icon) provided in the Print column for the corresponding payment entry.

Export the Receive Payments Register

If you want to export the added received payments entry in the Receive Payments Register page in the excel format, you can click (Excel icon). The added receive payments entries will be downloaded in the excel format.

Purchase Register

Purchase Register is a record of your company's purchases from suppliers. Each time when a purchase is made, the Purchase Invoice received from the Supplier should be recorded in the Purchase register page. Click Purchases Register in the Finance menu.
The Purchases Register page opens.

View Purchase Register

If you want to view the purchase entry details of the particular supplier,

In the Calendar, select the period for which you want to view the purchase entry details.
In the Supplier box, select a supplier.
In the Status box, select the status to view the purchase entry details.
Click . The purchase entry detail opens for the selected supplier and period.

Enable Permission for Purchase Recurring Transaction

If you want to add a new purchase entry by using the transaction details of an existing invoice number, you need to enable permission for accessing the Purchase recurring transaction option. To enable the permission for purchase recurring transaction, search for permission name "Purchase Recurring" in user 's permission page and enable both read and write permissions. Once you have enabled this permission, the purchase recurring transaction related option will be appeared while adding a new purchase entry.

Add a Purchase Entry

If you want to add a purchase entry, click (Add icon) provided in the upper right-corner of the Purchases Register. The Purchases Entry page opens.

Note: useful navigation options

(Journal button)-You can use the Journal option to view the purchase journal entry. Purchase Credit Journal Entry is the journal entry passed by the company in the purchase journal of the date when the company purchases any goods from the supplier on the terms of credit, where the purchases account will be debited.
(Pay Bill button) – used to navigate into the Pay Bills Entry page.
(Register button) – used to navigate into the Purchases Entry page.

Add a Purchase Entry Using the Purchase Recurring Option

If you want to add a purchase entry by using the purchase recurring option,

1. Click (use recurring button), all the saved recurring transactions page will open as below,
2. Select an invoice number from the recurring transactions list. Click the use icon. Once the invoice number is selected, it will retrieve the respective transaction details saved successfully in cuteOffice. All the input fields will be automatically filled up according to the selection of invoice number.

Note: to save a purchase entry as Recurring, enable the "Save As Recurring" flag to Yes when register a purchase entry. Once saved as recurring entry, it will be shown in the recurring transaction page when use "Use Recurring" option to register purchase entry.

Add a Purchase Entry Manually

If you want to add a purchase entry manually, click add button in the purchase register page, the purchase entry page will open as below,

In the Purchase Form Type field, select the purchase form type from the given types.
In the in the Tax Inclusive field, If the tax is inclusive for the purchase entry, enable to Yes; or else, No.
In the Supplier box, select a supplier from drop down list from suppliers' master. Note: If you want to add a new supplier, you can add a new supplier by clicking (Add icon) near the Supplier box.
In the Terms box, select the terms. Terms – Terms refers to the payment period. For example, if you select the terms as COD, then you need to pay cash on delivery. If you select 30 Days, then you need to pay the purchase amount within the 30 days of delivery.
In the Ship to box, select the shipping location. Note: once you have selected the shipping location, the shipping address will be automatically updated in the Address box.
In the Destination Country box, enter the destination country name.
In the Supplier Inv# box, enter the invoice number received from the supplier.
In the Date box, select the purchase date.
In the Account Number/Name box, select any one of appropriate chart of account from the list of charts of accounts.
Once you have selected the account number and name, the Description box shows the description for the corresponding selected account.
In the Units box, enter the number of items purchased by you.
In the Rate box, enter the rate of one item.
Once you have entered the units and rate of the item, the total amount will be calculated and displayed in the Amount box.
In the Project box, select for which project, the items are purchased.
In the Tax box, select a tax code from the given tax codes. The total amount for the items will be automatically updated in the Sub Total box.
In the Bill Delivery Status box, select the bill delivery status from the list.
In the Promised Date box, select the date when the payment will be made.
In the Freight box, select the tax percentage for the freight charges. The tax amount will be automatically updated in the Tax box.
In the GST Round Of box, user can use this option to round of GST amount. If need to round down the GST amount, click area 1 to show as "-", then enter round down amount, then click area 2 to enable round of; if need to round up the GST amount, click area 1 to show as "+", then enter round up amount, then click area 2 to enable round of.
In the Round Of box, user can use this option to round of the total amount. Refer to above point of GST round of.
Click Record. The purchase entry will be added and listed in the Purchases Register page.

Edit the Purchase Entry Details

If you want to edit any added purchase entry details in the Purchases Entry page, do the following steps,

Click (Edit icon) in the Edit column for the respective purchase entry. The Purchases Entry page opens and shows the added purchase details.
Click any box where you want to edit the details, and then edit the details in the respective box in the window.
Click Record. The changed purchase entry details will be updated.

Delete Any Added Purchase Entry

If you want to delete any added purchase entry, you can use delete option provided in the Delete column of the Purchases Register page,

Click (Delete icon) for the corresponding purchase entry. You receive a notification message “Are you sure to delete a record?”.

Click Yes. The selected purchase entry will be deleted.

Print the Invoice Details

If you want to print the invoice details of the particular purchase entry, click (Print icon) provided in the Print column for the corresponding purchase entry.

Export the Purchase Register

If you want to export the added purchase entries in the Purchases Register page in the excel format, click (Excel icon). The added purchase entries will be downloaded in the excel format.

Pay Bills

Pay Bills is a statement specifying the amount of money paid to the supplier for the purchase. The Pay Bills tab in the Finance menu helps you to add the details of the amount paid to the supplier. Navigate to finance module, and click Pay Bills in the Voucher Entry menu, the Pay Bills Register page opens as below,

View Paid Bills

If you want to view the paid bill details of a particular bank account, go to the pay bills register page,

In the Calendar, select the period for which you want to view the paid bill details.
In the Account box, select a bank account.
Click search icon. The page shows the paid bill details for the selected bank account and period.

Add a Pay Bill Entry

To add paid bill details,

Click (Add icon) provided in the upper right-corner of the Pay Bill Register. The Pay Bills Entry page opens.

Note: useful navigation options
- (Journal button)-You can use the Journal option to used to view the pay bills journal entry. Purchase Credit Journal Entry is the journal entry passed by the company in the purchase journal of the date when the company purchases any goods from the supplier on the terms of credit, where the purchases account will be debited.
- (Pay Bill button) – used to navigate into the Pay Bills Entry page.
- (Register button) – used to navigate into the Purchases Entry page.
In the Payment Type field, there are three types, namely Payment Voucher and Contra. Payments can be made in two scenarios: payments against an Invoice or Advance payment; Payments made without a Supplier Invoice.
- Type 1 PAYMENT VOUCHER-Payment Voucher option will be selected when the User intends to make a payment without an invoice. When this option is selected, User has to select the Supplier (which is a mandatory field) and the Supplier information will be picked from the Direct Payee Master. For such cases, User needs to create the details in the Direct Payee master, before raising the Pay Bill transaction. .
  Once you select the PAYMENT VOUCHER option in payment type, the Pay Bills Entry page shows the following fields need to be filled.
  - In the Bank Account box, select the debited bank account.
  - In the Paid To box, enter the bank name to which the amount has been transferred.
  - In the Address box, enter the address of the supplier who has received payment.
  - In the Date box, select the date of payment.
  - In the Payment Method box, select the mode of payment.
  - In the Currency box, select the currency type.
  - In the Account Name/Number box, select any one of appropriate chart of account from the list of charts of accounts. If you want to add additional account number, click (Add button) and add the account details. If you want to add a new account number, click (Add New Account Number button) and add the account details.
  - Once you have selected the account number and name, the Invoice Date box shows the invoice date and the Description box shows the description for the corresponding selected account.
  - In the Tax box, select a tax code from the given tax codes.
  - In the Amount applied box, enter the amount. Once you have selected the tax code and entered the amount, the GST and gross total will be automatically updated. The gain/loss amount will be automatically updated in the Gain/Loss box.
  - Click Record to save the paid amount details. The added payment details will be saved and listed in the Pay Bills Register page. Note: If you want to print the received payments details, click (Record and Print button).
- Type 2 Supplier-supplier option will be selected when the User intends to pay / settle an outstanding invoice to the Supplier. When this option is selected, User has to select the Supplier (which is a mandatory field) from the Supplier Master. User will enter the Payment amount and apply the amount against the Outstanding invoices by entering the Applied Amount field. While doing so, the Outstanding Invoice is adjusted against the Applied amount, and the Supplier Total Outstanding amount is thus calculated. If the Amount paid to the Supplier is to be treated as Advance, then user need to select the Apply Advance Payment and the amount will be treated as Advance Amount,
  
  Once you select the SUPPLIER option, the Pay Bills Entry page shows the following fields need to be filled.
  - In the Pay From Account box, select the debited bank account.
  - In the Supplier box, select a supplier from the list of suppliers. Once you have selected the supplier, the list of vendor invoices created for the respective supplier open.
  - In the Amount box, enter the amount paid to the supplier.
  - In the Date box, select the date of payment.
  - In the Payment Method box, select the mode of payment.
    a. If you want to add any credit note or credit memo, select the Apply Debit option.
    b. If you want to pay from any over payments, select the Apply Advance Payments option. A confirm dialog box opens and shows the following notification. Click Yes. The Over Payments field will be displayed below the Invoices field. The system will display the information of over payment if available. The Amount box in the Over Payments field shows the balance amount of the over payment. If you want to pay the amount from your over payment, enter the amount in the Amount Applied box in the Over Payments field. The total amount will be adjusted from the applied over payment amount.
    Note: If you want to attach any file regarding credit note or overpayments, click (Choose Files button) and attach the file.
  - In the Invoices field, enter the discount amount in the Discount box. Note: To manually enter the amount in the Invoices field, the respective users must be assigned with the Manual Amount Filling permission.
  - In the Amount Applied box, enter the paid amount. Once you have entered the paid amount, the total applied, finance charge, total received and out of balance will be automatically updated. The gain/loss amount will be automatically updated in the Gain/Loss box.
  - If you want to view the closed purchases details, enable to Yes in the View Closed Purchases option.
    
    If you want to view all the paid details, click (Pay All button).
  - Click Record to save the paid bill details. The added bill details will be saved and listed in the Pay Bills Register page. Note: If you want to print the paid bill details, click (Record and Print button).
- Type 3 CONTRA-Contra Payments in Cuteoffice Application is to settle the outstanding Invoices between the same Supplier & Customer. Please refer the Contra Entry voucher documentation for this. Select Supplier, and if the supplier is same as customer, click to select Contra.

Once you select the Supplier and Contra option in payment type, the Pay Bills Entry page shows the following fields need to be filled.

- In the Pay From Account box, select the debited bank account.
- In the Supplier box, select a supplier from the list of suppliers. Once you have selected the supplier, the list of vendor invoices created for the respective supplier open.
- In the Amount box, enter the amount paid to the supplier.
- In the Date box, select the date of payment.
- In the Payment Method box, select the mode of payment.

a. If you want to add any credit note or credit memo, select the Apply Debit option.
b. If you want to pay from any over payments, select the Apply Advance Payments option. A confirm dialog box opens and shows the following notification. Click Yes. The Over Payments field will be displayed below the Invoices field. The system will display the information of over payment if available. The Amount box in the Over Payments field shows the balance amount of the over payment. If you want to pay the amount from your over payment, enter the amount in the Amount Applied box in the Over Payments field. The total amount will be adjusted from the applied over payment amount.
Note: If you want to attach any file regarding credit note or overpayments, click (Choose Files button) and attach the file.

- In the Invoices field, select the invoice of the transaction and enter the discount amount in the Discount box. Note: To manually enter the amount in the Invoices field, the respective users must be assigned with the Manual Amount Filling permission.
- In the Amount Applied box, enter the paid amount. Once you have entered the paid amount, the total applied, finance charge, total received and out of balance will be automatically updated. The gain/loss amount will be automatically updated in the Gain/Loss box.
- If you want to view the closed purchases details, enable to Yes in the View Closed Purchases option.
  
  If you want to view all the paid details, click (Pay All button).
- Click to approve, or click to save to staging. The added bill details will be saved and listed in the Pay Bills Register page.

Contra Voucher Entry

Contra Function in Cuteoffice Application is to settle the outstanding Invoices between the same Supplier & Customer.

Contra voucher entry Scenario

Group companies can have multiple companies and Buy / Sell functions can have within these companies. In such scenarios Buy & Sell function happens raising the Purchase Invoices and Sales Invoice through the normal Purchase Register and Sales Register entry through our Cuteoffice Application. However these companies within the group do not make payments to each other, instead for such cases Contra Voucher entry in Pay Bills can be used.

Prerequisites

To raise a Contra Voucher the following conditions should be met

Supplier Name (Supplier Code) & the Customer Name (Customer code) should be the same
Contra Amount Entered should be Less Than Purchase Applied Amount in Pay Bill
After the Pay Bill data is entered and Record Button is clicked, Application Control will navigate to Customer Receipts Payment. If the client cancels the Customer Receipt Payment entry then the associated Pay Bills entry entered will be deleted by the application automatically. In other words, for Contra Entry Pay Bills and Customer Receipts should be done immediately without a break
In Customer Receipts Entry, Contra Amount that is displayed should be allowed to Edit

Contra voucher entry Examples

Example 1 – Contra Amount = 0 ; Purchase Invoice Amount Applied = 1000

The above example means that the Client wants to pay $1000 to a Purchase Invoice and have the Sales Invoice Pay $1000.

GL Entry for the above will be:

Pay Bills

Dr Sundry Creditors - $1000

Cr Contra Account - $1000 (Contra Account code is configured in Account Link Menu)

Customer Receipts

Dr Contra Account - $1000 (Contra Account code is configured in Account Link Menu)

Cr Sundry Debtors - $1000

Example 2 – Contra Amount = 600 ; Purchase Invoice Amount Applied = 1000

The above example means that the Client wants to pay $1000 to a Purchase Invoice and have the Sales Invoice Pay $600. The balance $400 will be paid from the Bank Account as mentioned in the Pay Bill entry

Pay Bills

Dr Sundry Creditors - $1000

Cr Contra Account - $1000 (Contra Account code is configured in Account Link Menu)

Cr Bank A/c - $400

Customer Receipts

Dr Contra Account - $1000 (Contra Account code is configured in Account Link Menu)

Cr Sundry Debtors - $1000

Steps to Operate

In Pay Bills screen Select Contra Option and proceed the Pay Bill Transaction as usual
Enter the Contra Amount Example 600
Enter the Purchase Amount Applied – Example 1000
Click Record Button
Application will automatically load the Customer Receipt and allow to complete the transaction with Applied Amount as $1000
If the Amount applied entered is not equal to $1000, application will display an error and proceed only if the amount entered is $1000
GL entries will be created as mentioned above

The following bug will be fixed and a GIT issue has been raised:

Customer Name (Customer code) in Customer Receipts screen will not be allowed to change. This is controlled through a configuration allowing Customer Name change, will be set to False
Contra Amount Entered should be Less Than Purchase Applied Amount in Pay Bill
In Customer Receipts Entry, Contra Amount that is displayed should be allowed to Edit.

Contra Voucher against Receive Payment

Example 3 : Contra Account in Pay bill - $1080 Purchase Invoice - $1080 Sales Invoice - $100000 Receive Payment (Normal) - $98920 Contra Receive Payment - $1080

To raise a Contra Voucher against Receive Payment the following steps to operate.

Supplier Name (Supplier Code) & the Customer Name (Customer code) should be the same.
Raising Sales Invoice in Sales register (ex: $ 100000)
Raising Purchase Invoice in Purchase register (ex: $ 1080)
Normal receive payment entry in Bank with offset contra amount (ex: Amount received $ 98920)
Contra Pay bill entry for the amount $1080 . Choose Contra Account code in Pay from Account
Contra Receive payment entry to Offset Paybill . Choose Contra Account code is configured in Account Link Menu
The Customer Receipt Payment entry entered in Contra then the associated Pay Bills entry entered in Contra will be cancelled by the application automatically.

Output of the Scenario

1. Sale Invoice entry

2. Purchase Invoice entry

3. Contra Pay bill entry

4. Normal Receive Payment entry

5. Contra Receive Payment entry

GL entries will be created as mentioned above.

Edit the Pay Bills

If you want to edit any added purchase entry details in the Pay Bills page, do the following steps,

Click (Edit icon) in the Edit column for the respective pay bill. The Pay Bill Entry page opens and shows the added payment details.
Click any box where you want to edit the details, and then edit the details in the respective box in the window.
Click. The changed pay bill entry details will be updated.

Delete Any Added Pay Bills Entry

If you want to delete any added pay bill entry, you can use delete option provided in the Delete column of the Pay Bills page,

Click (Delete icon) for the corresponding pay bills entry. You receive a notification message “Are you sure to delete a record?”.

Click Yes. The selected pay bill entry will be deleted.

Print the Pay Bills Details

If you want to print the invoice details of the particular pay bills entry, click (Print icon) provided in the Print column for the corresponding pay bills entry.

Export the Pay Bills

If you want to export the pay bills records in the Pay Bills page in the excel format, click (Excel icon). The pay bills entry will be downloaded in the excel format.

Transactions Journal

In Transactions Journal page, user can search for any financial transaction entered in cuteOffice finance module.

View Transactions Journal Entry

To view transaction journal,

Click Transactions Journal in Finance menu, the Transaction Journal page opens as below,
In the Transactions Journal page, select any one transaction journal type from the given types.
In the Calendar, select the date range.
Click (Search icon). All qualified transactions journal will be shown in the page.

Edit Transaction Journal Entry

To edit any transaction journal entry in the Transaction Journal page,

Click (Edit icon) in the Edit column for the respective transaction journal entry. The respective page opens and shows the journal entry details.

Click any box where you want to edit the details, and then edit the details in the respective box in the window.
Click. The transaction journal entry details will be updated.

Delete Any Transaction Journal Entry

If you want to delete any transaction journal entry, you can use delete option provided in the Delete column of the Transactions Journal page, click (Delete icon) for the corresponding transaction journal entry. The selected transaction journal entry will be deleted. to confirm with sekar if need to prompt confirmation notification

Print the Transaction Journal Entry

If you want to print the particular transaction journal entry, click (Print icon) provided in the Print column for the corresponding transaction journal entry.

Export the Transaction Journal Entry

If you want to export the added transaction journal entry in the Transactions Journal page in the excel format, click (Excel icon). The added transaction journal entries will be downloaded in the excel format.

Bank Register

Bank Register are reports that is generated based on the entries made through the various vouchers. The selection for these reports would be Bank as defined in the Chart of Accounts master. The Bank Register tab in the Finance menu used to view the transaction statement of the particular bank account.

View Bank Register

To view the transaction statement,

Click Bank Register in the Finance, the Bank Register page opens.
In the Account box, select an account from the list of bank accounts.
In the Calendar, select the date range from the current financial year.
Click (search icon). The Bank Register page shows the transaction detail of the selected account.

Edit the Transaction Detail

To edit any transaction detail listed in the Bank Register page,

click (Edit icon) provided in the Edit column for the respective transaction. The selected transaction page opens. You can edit the transaction detail if you want.
Click. The transaction details will be updated.

Transfer Money

The Transfer Money tab in the Finance menu is used to record transfer money from one bank account to another bank account. Finance users can transfer the money with multi foreign currency banks.

To transfer money,

Click Transfer Money in the Finance, the Transfer Money page opens,
In the Transfer No box, the transfer number will be updated automatically.
In the Date box, select the date of money transfer.
In the Transfer Money From box, select an account where you want to transfer money from. Note: Once you select the debit account, the Transfer Money page shows the account balance of the selected account.
In the Transfer Money To box, select an account where you want to transfer money to. Note: Once you select the credit account, the Transfer Money page shows the account balance of the selected account.
In the Amount box, enter the amount you want to transfer.
In the Payment Method box, select the payment method.
Click (Transfer Money icon). The entered amount will be transferred to the respective selected account. The transfer money detail will be moved and listed in the Transaction Journal page. Note: If you want to print the transferred money details, click (Transfer and Print icon).

Petty Cash Register

Petty cash register helps companies ensure that the funds are used appropriately and the transactions are properly documented. Having such a system in place serves as an internal control to protect the business against theft and fraud, and it supports the larger, general ledger reconciliation process. Petty Cash Register are reports that is generated based on the entries made through the various vouchers. The selection for these reports would be Cash as defined in the Chart of Accounts master. This report is to list down the transaction made from these nature of accounts with a running balance.

Bank Reconciliation Register

Bank Reconciliation is the process of verifying the bank statement with the reconciliation report to ensure that the records such as check register, general ledger account, and balance sheet, are correct. This is done by comparing the company's recorded amounts with the amounts shown on the bank statement.

Any differences must be justified. When there are no unexplained differences, you must state that the bank statement has been reconciled. Once you have reconciled the bank statement, the reconciled bank statement will be shown in bank reconciliation report and the general ledger.

Click Bank Reconciliation tab in the Finance menu, the Bank Reconciliation Register page opens as below,

View A Bank Reconciliation Details

To view the bank reconciliation details of the particular bank account,

In the Calendar box, select the period for which you want to view the bank reconciliation details.
In the Account Name box, select an account.
Click (search icon). The bank reconciliation detail opens for the selected account and period.

Reconcile Any Bank Statement

To reconcile any bank statement,

Click (Add icon) provided in the upper right-corner of the Bank Reconciliation Register, the Bank Reconciliation page opens.
In the Account box, select an account from the list of accounts.
In the Bank Statement Balance box, enter the balance of the selected account.
In the Bank Statement Date box, select the bank statement date.
Click (search icon). The list of job numbers opens including date and cheque number.
Select the job number.
Click , the selected bank account is reconciled. Click to reconcile and print report. Click to save as draft.

Edit Any Reconciled Bank Statement

To edit any reconciled bank statement in the Bank Reconciliation Register page,

Click (edit icon) in the Edit column for the respective reconciled bank statement. The page opens and shows the respective reconciled bank statement.

Click any box where you want to edit the details, and then edit the details in the respective box in the window.
Click Record. The changed reconciled bank statement details will be updated.

Delete Any Added Reconciled Bank Statement

If you want to delete any added reconciled bank statement, you can use delete option provided in the Delete column of the Bank Reconciliation Register page,

Click (Delete icon) for the corresponding reconciled bank statement. You receive a notification message.

Click Yes to confirm deletion of the selected reconciled bank statement.

Print the Reconciled Bank Statement

If you want to print the reconciled bank statement, click (Print icon) provided in the Print column in the Bank Reconciliation Register page.

Export the Reconciled Bank Statement

If you want to export the added reconciled bank statement in the Bank Reconciliation Register page in the excel format, you can use export to excel option in the Excel column. Click (Excel icon) of the respective reconciled bank statement. The reconciled bank statement will be downloaded in the excel format.

Remittance Advices

A remittance advice is an acknowledge sent by a customer to a supplier, informing the supplier that an invoice has been paid. The purpose of the remittance advice is to match a customer's payment with the invoice. The remittance advice is also sent to the supplier to inform that the payment has been received against the payment voucher. Click Remittance Advices tab in Voucher menu, the remittance page opens as below,

View Remittance Advices

to view the remittance advices,

Click Remittance Advices tab in Voucher menu to open the Remittance page
In the Payment Type box, select the payment type from Pay Bills or Payment Vouchers.
In the Calendar box, select the date range you want to view the remittance advices.
Click (search icon), the page shows the remittance advices for the selected payment type and period.

Edit Any Remittance Advice

To edit any remittance advice in the Remittance Advices page,

Click (edit icon) in the Edit column for the respective remittance advice. The respective page opens and shows details of the remittance advice.

Edit the details in the respective box as needed.
Click. The changed remittance advice details will be updated.

Print Any Remittance Advice

If you want to print the remittance advice, click (Print icon) provided in the Print column in the Remittance Advices page.

Find Transactions

The Find Transactions tab in the Finance menu is used to view the details of the transactions such as sales and purchase transactions of both customer and supplier. Click Find Transactions in the Finance, the Find Transactions page opens.

to view the transaction details of particular customer/supplier

In Filter box, click to select Customer/Supplier.
In the Search By box, select Customer or Supplier.
In the Name box, select the name of the customer or supplier.
In the Calendar, select the date range.
Click (search icon), the transaction details for the selected customer/supplier opens.

to view the transaction details for the particular sales invoice,

to view the transaction details for the particular purchase invoice,

Item Transactions

The Item Transactions tab in the Finance menu is used to view the item details of the transactions of sales and purchases of both customer and supplier. Click Item Transactions in the Finance, the Item Transactions page opens as below,

User can use the column filters to search for specific item sales/purchase details,

Bad Debt Write-Off transaction

Step 1: Check your aging accounts receivable

Review other invoices or receivables that should be considered as bad debt using the Accounts Receivable Aging Detail report.

Go to Reports
Find and open an Accounts Receivable Aging Detail report.
Check which outstanding accounts receivable should be written off.

Step 2: Create a bad debts expense account

If you haven't already, create a "bad debts" expense account.

Go to Master and select Chart of accounts
Click add to create a new account.
Choose Detail account
From the Parent Account Type ▼ dropdown, select Expenses.
From the Parent Account Sub Type ▼ dropdown, select Expenses
Enter Account Number
Enter Account name as Bad debts in Account Name field.
Select Save and Close.

Step 3: Create a Credit Note Invoice

Go to Voucher entry and Select Sales Register
Select + icon.
Choose Sales form type as Credit Note
Under Customers, select Customer name.
Choose Bad Debts from Account Number/Name.
Enter the write off amount.
Select Save and Close.

Step 4: Apply the credit note against invoice

Go to Voucher entry and Select Receive Payment
Select + icon.
Under Customers, select Customer Name
Outstanding Transactions and Credit Note available in the section,
Enter Credit amount against the invoice number under Amount Applied.
Enter Credit amount value under Amount Applied.
Check Out of Balance should be Zero.
Select Save and Close.

The uncollectible receivable now appears on your Profit and Loss report under the Bad Debts expense account.

Bad Debt Write-Off for Journal Entry

Step 1: Check your Opening Balance in the Accounting records (COA) to write off

Go to COA
Check which accounts to be written off.
Find the amount in accounting to write off.

Step 2: Create a bad debts expense account

If you haven't already, create a "bad debts" expense account.

Go to Master and select Chart of accounts
Click add to create a new account.
Choose Detail account
From the Parent Account Type ▼ dropdown, select Expenses.
From the Parent Account Sub Type ▼ dropdown, select Expenses
Enter Account Number
Enter Account name as Bad debts in Account Name field.
Select Save and Close.

Step 3: Create a Journal to write off

Go to Transaction Journal under Voucher Entry
Select + icon.
1^st Line item
a) Choose Outstanding Account name

b) Enter the amount on the credit side for Asset

c) Enter the amount on the debit side for Liability
2nd Line item
a) Choose Bad debt from the Account Name

b) Enter the write off amount on the debit side for Asset

c) Enter the write off amount on the credit side for Liability
Select Save and Close.

The uncollectible or payable amount now appears on your Bad debt Expense, and they are removed as assets/Liability from the balance sheet.

This results the total expense either increase or decrease in the Profit and Loss statement.

Voucher Staging Entries

CuteOffice provides finance voucher staging feature if client company wants to apply approve workflow for voucher entries. Finance vouchers entered in finance module in Voucher Staging Entries menu will be moved into financial transactions only after vouchers are approved. The vouchers will not be reflected in any financial reports or the balances will not be affected until the vouchers are approved.

Enable Finance Approval Option

Step1: To enable Approval Option to Accounts at Company Level

In Cute Office, navigate to Admin module, click Company menu and click edit icon in selected company.
Navigate to Setting page, search for setting configuration name Finance - Approval option for Account Vouchers,
Click edit icon, change setting Value as true (Note: by default the value is false)
Click Save to save setting for finance approval.

Step 2: Enable Permission to View Approval Option & Staging Menu’s at User Level

In Cute Office, navigate to Admin module, click Users menu and click edit icon in selected user.
Navigate to Permissions tab. To view Save & Approve Button in Voucher Entry screens and to view Voucher Staging Menu, in user's permission page, enable below Read & Write permissions (click filter and filter "approvalstaging").
Click Save to save permissions.

If finance approval functionality is enabled through Step 1 at the company level and Step 2 at the User level. All Voucher Entry screens will show Save To Staging Button by default

Step 3: Approve the Staging Vouchers

Once voucher entries are saved to staging, user with permission to approve staging voucher entries can review all staging vouchers in Voucher Staging Entries menu as below. Click to review specific vouchers and click Approve button to approve. After approval, vouchers will be integrated to financial transactions.

Integration Staging

This document briefs the steps that needs to be done for implementing the purchase module and payroll module integration to financial accounting module.

Purchase Module Integration

From Purchase module, customers can opt for integrating below data

Stock value of items purchased to Accounting module (at Purchase Cost)
Invoices created in purchase module against the Purchase Order raised

As part of Integration, the vouchers will be generated for the above 2 scenarios (as selected by the customer) and linked to the Financial Module Staging location. Subsequently, customer need to approve the vouchers in the Staging location which will then reflect in the Accounting entries as per the configuration created.

Please follow the below steps to post entries from the Purchase Module to Financial Module Staging location.

Step 1: To enable Purchase Module Integration to Accounts at Company Level

In Cute Office, navigate to Admin module, click Company menu and click edit icon in selected company.
Navigate to Setting page, search for setting configuration name Purchase Module Linked To Finance, this setting is to define whether the user wants to Link Purchase module to Finance module.
Click edit icon, change setting Value as Yes (Note: by default the value is No), and click Save to save setting.
And if user wants to integrate purchase module through item stock, then navigate to Setting page, search for setting configuration name ItemLinking, and change setting Value as Yes, the Post to Accounts option will be available after item inspected and the stock value can be posted to Finance module in the Receiving Entry table of the Purchase Order; If user do not want to integrate through item stock, set value as No, user can integrated purchase module to finance module via invoices created in Purchase Orders.

Step 2: Enable Permission to Configure GL Accounts Codes to be linked to Accounting Module at User Level

Note: It is highly recommended to define permission in user role and then assign user roles to a specific user account, so that users who perform same duty in cuteOffice will have same permissions. Roles are defined by a set of permissions to different functionalities in cuteOffice system. Based on company operation needs or organization structure, system admin user can create finance roles, such as finance manager etc., and give required permission to these roles and assign role to user.

To define permission in user role,

Click Roles tab, all existing roles created in system will be displayed as below.
Click (add icon), the adding new role window open as below,
In Name box, enter the new role name, such as "Finance Manager"
In Description box, enter description of the new role.
Based on the function of the new role, search for relevant module and permissions.
Search and enable below Read & Write permission (click filter and filter "inventoryLinkedAccounts").
Click Save to save the new role.
To assign role to user, click Users menu and click edit icon in selected user.
Navigate to user's Basic Info tab, in Role box, search and select "Finance Manager" role.
Click Save. The new permission assigned to role "Finance Manager" will be granted to user.

To enable permission to a specific user

In Cute Office, navigate to Admin module, click Users menu and click edit icon in selected user.
Navigate to Permissions tab. To be enable to configure GL accounts codes to be linked to Accounting module, in user's permission page, enable below Read & Write permission (click filter and filter "inventoryLinkedAccounts").
Click Save to save user's permission configuration.

Step 3: Linking GL Account Code to Items

Note: The Link Account Setup Menu will be available only if Permission is granted through Step 2.

Navigate to Finance module, click Link Account Setup menu,
Click Inventory Linked submenu, the inventory link account page opens as below,
In each of the category box, click and select to link accounts for Asset Category and Non-Asset Category and Goods In Transit Account.
Click Save to save updates.

Step 4: Posting Purchase Orders to Financial Accounting Module

Note: Posting PO to finance function will be available only if setting configurations in Step 1 setting configuration name Purchase Module Linked To Finance is enabled as Yes at the company level.

To post PO to accounts,

Navigate to Procurement module, click Purchase Order menu.
Click the PO key to open PO details,
Post To Accounts tab will be available in both Receiving Entry (if ItemLinking setting is configured as Yes at company level) & Invoice Entry Table.
- If user chooses to Post to Accounts via item stock value, after item inspected in PO, the option will show in Receiving Entry table as below,
- If user chooses to Post to Accounts via invoices, after invoice details are entered in Invoice Entry, the option will show in Invoice Entry table as below,
Click , a confirmation notification will prompt,
Click Yes to confirm posting PO to finance staging.

Step 5: Enable Permission to View / Post Vouchers in Staging Location

In Cute Office, navigate to Admin module, click Users menu and click edit icon in selected user.
Navigate to Permissions tab. To view staging menu in Finance, in user's permission page, enable below Read & Write permissions (click filter and filter "stagingPurchaseInvoice" and "stagingPurchaseItemReceiving").
Click Save to save permissions.

Step 6: To Approve the Purchase Integration Staging in Finance Module

Navigate to Integration Staging menu,
To view and approve posted Receiving Item stock value or Invoices from Purchase module,
- If user posted via item stock value in Receiving Entry table in PO, click Items Stock Staging tab, select relevant vouchers and click to approve,
- If user posted via invoices, click Purchase Invoice Staging tab, select relevant vouchers and click to approve,

Payroll Module Integration

Follow the below steps to post entries from Payroll to Finance module Integration Staging.

Step 1: Configure Payroll Admin Settings

Go to Payroll module, navigate to Admin menu, click Settings to open settings page as below,
Scroll down the page to find Account Payment box, and select "Groupby Paycycle" as account payment setting.
Click Submit to save payroll setting configuration.

Step 2: Configure Admin Company Settings at Company Level

In Cute Office, navigate to Admin module, click Company menu and click edit icon in selected company.
Navigate to Setting page, search for setting configuration name Financial Groups,
Click icon of Financial Groups setting name,
Check and edit Value box if needed.
Click Save to save company settings.

Step 3: Enable Permission to View Project Costing and Post Payroll to Accounts at User Level

To define permission in user role,

Click Roles tab, all existing roles created in system will be displayed as below.
Click (add icon), the adding new role window open as below,
In Name box, enter the new role name, such as "Finance Manager"
In Description box, enter description of the new role.
Based on the function of the new role, search for relevant module and permissions.
Search and enable below Read & Write permissions (click filter and filter permission names "projectCosting","payrollJournal", "payrollJournalReport").
- projectCosting - To Enable Project Payroll Costing menu in Payroll
- payrollJournal - To Enable Staging Journal Resgister in Finance
- payrollJournalReport - To Enable Payroll Journal Report in Finance
Click Save to save the new role.
To assign role to user, click Users menu and click edit icon in selected user.
Navigate to user's Basic Info tab, in Role box, search and select "Finance Manager" role.
Click Save. The new permission assigned to role "Finance Manager" will be granted to user.

To enable permission to a specific user

In Cute Office, navigate to Admin module, click Users menu and click edit icon in selected user.
Navigate to Permissions tab. To be enable to configure GL accounts codes to be linked to Accounting module, in user's permission page, enable below Read & Write
permissions (click filter and filter permission names "projectCosting","payrollJournal", "payrollJournalReport")
Click Save to save user's permission configuration.

Step 4: Configure Employee's Finance Group in HRM Employee's Salary Configuration

Go to HRM module, navigate to Employee menu, click view all to open employee list.
Search for an specific employee and click to open the HRM details, and navigate to Payroll Salary Information page as below. In Others section, Finance Groups box, click to choose Finance Group for the specific employee.
Click Save to save employee's finance group information.

Step 5: Map G/L Debit or Credit Account to Pay Code Payroll Master

Go to HRM-Payroll module, navigate to Master menu, click to open pay code master list.
Select a pay code, and click edit icon,
To map Single Debit Account Code Against Finance Group or Single Credit Account Code or Against Finance Group
- Tick relevant box in area 1 in above screenshot.
- If or is/are ticked, the employee finance group details will be shown in area 2, and user need to select G/L debit or credit account code in each of the employee finance group in area 2.
- Click Submit to save account mapping information.
To map account code in one stretch, use the bulk update option of G/L Account Code for multiple pay codes, click , the GL Account Code Bulk Update window opens as below,
- Select a pay code in area 2 in above screenshot,
- If user wants to map G/L account code against finance group, tick relevant box in area 3, and select G/L account code to map to each finance group as shown in below yellow highlight area,
- Or if user want to map G/L account code, select relevant G/L account code in area 4.
- Fill up rest of the details and click Save to save mapping details.

Step 6: To Generate & Print Project Payroll Costing

Go to HRM-payroll module, navigate to Reports menu, click Project Payroll Costing submenu,
Select relevant information in Payroll Period/Project/Department/Employees fields,
Click to generate project payroll costing report; Click or to download reports.

Step 7: Post Payroll to Accounts

Once above four steps are configured, user will be able to integrate payroll to finance module (Post payroll to finance staging).

Go to Payroll module, navigate to Operation menu, click to open Payroll history (Note: only approved payroll details will be shown in Payroll History page).
In Choose Pay Period box, select pay period to post in accounts, all approved employees' payroll for selected pay period will be displayed,
Tick the box in front of employees' name to select employee(s) to post to accounts,
Click Post to Accounts Button at the top right corner of the payroll history page, a confirmation notification window will prompt up as below,
Click Yes to confirm posting to accounts. Note: once employees' payroll are posted to accounts, the payroll history records will be disabled from further action such as deletion.

Step 8: To View/Approve Staging Payroll Journal in Finance Integration Staging

Navigate to Finance module, go to Integration Staging menu, click Payroll Staging to open the staging payroll journal page as below,
In the date field, select period then click search icon to show staging voucher.
To view staging payroll journal details, click icon to expand payroll payment details,
To edit staging payroll journal, click edit icon, the payroll staging journal will open as below, edit fields where needed, then click to save & approve staging payroll journal.

Configuration and Journal details :

Monthly Reports

Monthly finance reports include below reports: Trial Balance, Trial Balance YTD, General Ledger(Detail), Profit and Loss, Project P&L, Project P&L Transpose, Multi Period P&L, Balance Sheet, Transactional Journal, Transactional Profit, Accounts Journal, Transaction Report.

Trial Balance Report

To generate trial balance report,

Navigate to Monthly Reports menu in finance module, click Trial Balance to open trial balance report page.
user can select period from calendar field 1, or if user wants to generate report by calendar month, tick Show monthly box.
Click search icon, the trial balance report for selected period will show in screen.
Click to download report in xlsx format, click to download report in PDF format.

Trial Balance YTD (Year-to-date) Report

To generate trial balance YTD report,

Navigate to Monthly Reports menu in finance module, click Trial Balance YTD to open trial balance YTD report page.
user can select date period from calendar field 1, or if user wants to generate report by calendar month, tick Show monthly box.
Click search icon, the trial balance YTD report for selected period will show in screen.
Click to download report in xlsx format, click to download report in PDF format.

General Ledger (Detail) Report

To generate general ledger detail report,

Navigate to Monthly Reports menu in finance module, click General Ledger (Detail) to open report page.
user can select date period from calendar field.
Click search icon, the general ledger detail report for selected period will show in screen.
Click to download report in xlsx format, click to download report in PDF format.

Profit And Loss Report

To generate profit and loss report,

Navigate to Monthly Reports menu in finance module, click Profit and Loss to open report page.
user can select date period from calendar field 1 to generate profit and loss report for selected date range.
In field 2, select account type to generate report (user can select all accounts or accounts with value).
Or if user wants to view and compare variance between current month and the previous period, tick the Pre Period box in field 3. Then select month & year.
Once month and year are selected, click search icon, the profit and loss report for selected period and previous month and the variance will show in screen.
Click to download report in xlsx format, click to download report in PDF format.

Project P&L

To generate project profit and loss report,

Navigate to Monthly Reports menu in finance module, click Project P&L to open report page.
In project field, click to select project.
In calendar field, select date range.
In report type, select summary or detail report.
Click search icon, the project P&L report for selected period will show in screen.
Click to download report in xlsx format, click to download report in PDF format.

Project P&L Transpose

To generate project profit and loss report transpose,

Navigate to Monthly Reports menu in finance module, click Project P&L Transpose to open report page.
In project field, click to select project.
In calendar field, select date range.
Click search icon, the project P&L transpose report for selected period will show in screen.
Click to download report in xlsx format.

Multi Period P&L

To generate multi period profit and loss report,

Navigate to Monthly Reports menu in finance module, click Multi Period P&L to open report page.
In calendar field, click to select date range to view P&L report.
Click search icon, the multi period P&L report for selected period will show details of income, cost of sales, expense, other income, other expenses and net profits by month as in above screenshot.
Click to download report in xlsx format. not working check

Balance Sheet

To generate balance sheet report,

Navigate to Monthly Reports menu in finance module, click Balance Sheet to open report page.
In calendar field, select date and year.
Click search icon, the balance sheet report for selected period will show in screen.
Or if user wants to view previous month balance sheet and the variance, tick the Pre Period box, the selected month and previous month and variance data will show as below,
Click to download report in xlsx format, click to download report in PDF format.

Transaction Journal

The Transaction Journal Report shows debits and credits for each transaction and provides a more focused view of amounts and accounts.

To generate transaction journal report,

Navigate to Monthly Reports menu in finance module, click Transaction Journal to open report page.
In calendar field, select date range,
In transaction type field, select type of transaction to view.
Click search icon, the transaction journal that meets criteria will show in screen.
Or user can use filters to customize the transaction journal report(filter options including name, Txn number, report type),
Click to download report in xlsx format, click to download report in PDF format.

Transactional Profit Report

To generate transaction profit report,

Navigate to Monthly Reports menu in finance module, click Transaction Profit to open report page.
In calendar field, select date range.
In Job Code, click to select project.
Click search icon, the transaction profit report for selected period and project will show in screen.
Click to download report in xlsx format, click to download report in PDF format.

Accounts Journal

To generate accounts journal report,

Navigate to Monthly Reports menu in finance module, click Accounts Journal to open report page.
In calendar field, select date range,
In Accounts field, select account or all accounts,
Click search icon, the accounts journal report for selected period will show details of income, cost of sales, expense, other income, other expenses and net profits by month as in below screenshot.
Click to download report in xlsx format, click to download report in PDF format.

Transaction Report

To generate transaction report,

Navigate to Monthly Reports menu in finance module, click Transaction Report to open report page.
In calendar field 1, select date range,
Or user can click filter icon in area 2 to open report filter page, and select column filters, then click Show to show selected filters,
Click search icon, the transaction report for selected period will show, click to download report in xlsx format, click to download report in PDF format.

Customer Reports

Customer reports include below reports: Receivables Ageing, Receivables Ageing Detail, Receivables Ageing Detail (Portrait), SOA-Sales, Customer Ledger, Customer Summary, Sales Report MonthWise, Project Receivables Ageing.

Receivables Ageing Summary Report

To generate receivables ageing report,

Navigate to Customer Reports menu in finance module, click Receivables Ageing to open report page.
In calendar field, click to select a date as ageing report by date.
In Currency type field, select all currencies or a specific currency type.
Click search icon, the receivables ageing report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.
Click filter icon to open customer filter, and select customer name, then click show, the selected customer(s)' receivables ageing report will show.

Receivables Ageing Detail Report

To generate receivables ageing detail report,

Navigate to Customer Reports menu in finance module, click Receivables Ageing Detail to open report page.
In calendar field, click to select a date as ageing report by date.
In Currency type field, select all currencies or a specific currency type.
Click search icon, the receivables ageing report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.
Click filter icon to open customer filter, and select customer name, then click show, the selected customer(s)' receivables ageing detail report will show.

Receivables Ageing Detail Portrait Report

To generate receivables ageing detail report in portrait format,

Navigate to Customer Reports menu in finance module, click Receivables Ageing Detail (Portrait) to open report page.
In calendar field, click to select a date as ageing report by date.
In Currency type field, select all currencies or a specific currency type.
Click search icon, the receivables ageing report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.
Click filter icon to open customer filter, and select customer name, then click show, the selected customer(s)' receivables ageing detail portrait report will show.

Statement of Account (SOA)-Sales Report

To generate SOA-Sales report,

Navigate to Customer Reports menu in finance module, click SOA-Sales to open report page.
In calendar field, click to select a date as report by date.
Click search icon, the sales report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.
Click filter icon to open customer filter, and select customer name, then click show, the selected customer(s)' SOA-sales report will show.

Customer Ledger

To generate customer ledger report,

Navigate to Customer Reports menu in finance module, click Customer Ledger to open report page.
In calendar field, click to select date range to view customer ledger.
In Currency type field, select all currencies or a specific currency type.
If user wants to view customer ledger that includes zero value accounts, tick the Include Zero's box.
Click search icon, the customer ledger report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.
Click filter icon to open customer filter, and select customer name, then click show, the selected customer(s)' ledger report will show.

Customer Summary Report

To generate customer summary report,

Navigate to Customer Reports menu in finance module, click Customer Summary to open report page.
In calendar field, click to select date range to view customer ledger.
In report type field, select summary or detail report type.
Click search icon, the customer summary report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.

Sales Report MonthWise Report

To sales month wise report,

Navigate to Customer Reports menu in finance module, click Sales Report MonthWise to open report page.
In Multi Period box, tick if user wants to view sales report for selected period; untick if user wants to view by month.
In With Ex-Rate box, tick if want to include exchange rate.
In calendar field, if multi period is ticked, user will be able to select a date range; if multi period is not ticked, user will be able to select month and year to generate report.
In Currency type field, select all currencies or a specific currency type.
Click search icon, the sales report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.
Click filter icon to open customer filter, and select customer name, then click show, the selected customer(s)' sales month wise report will show.

Project Receivables Ageing Report

To generate Project Receivables Ageing report,

Navigate to Customer Reports menu in finance module, click Project Receivables Ageing to open report page.
In Project field, click to select all project or a specific project.
In calendar field, click to select a date as ageing report by date.
In Currency type field, select all currencies or a specific currency type.
Click search icon, the receivables ageing report for selected period will show in screen, click to download report in xlsx format.
Click filter icon to open customer filter, and select customer name, then click show, the selected customer(s)' receivables ageing detail portrait report will show.

Supplier Reports

Supplier reports include below reports: Payables Ageing, Payables Ageing Detail, Payables Ageing Detail (Portrait), SOA-Purchases, Supplier Ledger, Supplier Summary.

Payables Ageing Summary Report

To generate payables ageing report,

Navigate to Supplier Reports menu in finance module, click Payables Ageing to open report page.
In calendar field, click to select a date as ageing report by date.
In Currency type field, select all currencies or a specific currency type.
Click search icon, the payables ageing report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.
Click filter icon to open suppliers filter, and select supplier's name, then click show, the selected supplier(s)' payables ageing report will show.

Payables Ageing Detail Report

To generate payables ageing detail report,

Navigate to Supplier Reports menu in finance module, click Payables Ageing Detail to open report page.
In calendar field, click to select a date as ageing report by date.
In Currency type field, select all currencies or a specific currency type.
Click search icon, the payables ageing report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.
Click filter icon to open suppliers filter, and select supplier's name, then click show, the selected supplier(s)' payables ageing detail report will show.

Payables Ageing Detail Portrait Report

To generate payables ageing detail report in portrait format,

Navigate to Supplier Reports menu in finance module, click Payables Ageing Detail (Portrait) to open report page.
In calendar field, click to select a date as ageing report by date.
In Currency type field, select all currencies or a specific currency type.
Click search icon, the payables ageing report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.
Click filter icon to open suppliers filter, and select supplier's name, then click show, the selected supplier(s)' payables ageing detail portrait report will show.

Statement of Account (SOA)-Purchases Report

To generate SOA-Purchases report,

Navigate to Supplier Reports menu in finance module, click SOA-Purchases to open report page.
In calendar field, click to select a date as report by date.
Click search icon, the SOA purchases report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.
Click filter icon to open supplier filter, and select supplier name, then click show, the selected supplier(s)' SOA-purchases report will show.

Supplier Ledger

To generate supplier ledger report,

Navigate to Supplier Reports menu in finance module, click Supplier Ledger to open report page.
In calendar field, click to select date range to view supplier ledger.
In Currency type field, select all currencies or a specific currency type.
If user wants to view supplier ledger that includes zero value accounts, tick the Include Zero's box.
Click search icon, the supplier ledger report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.
Click filter icon to open supplier filter, and select supplier name, then click show, the selected supplier(s)' ledger report will show.

Supplier Summary Report

To generate supplier summary report,

Navigate to Supplier Reports menu in finance module, click Supplier Summary to open report page.
In calendar field, click to select date range to view supplier ledger.
Click search icon, the supplier statement summary report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.

Tax Reports

Tax reports include below reports: GST F5 Return, Sales Tax Analysis, Receipt Tax Analysis, Purchase Tax Analysis, Payment Tax Analysis, Journal Tax Analysis.

GST F5 Return

Authorized user can generate GST F5 return report which includes details of: the sale of goods and services to customers. purchases made from the GST registered businesses. amount of GST collected.

To generate GST F5 Return report,

Navigate to Tax Reports menu in finance module, click GST F5 Return to open report page.
In calendar field, click to select date range to generate GST F5 return.
In Report type field, click to select report type as Summary or Detail report.
Click search icon, the GST F5 Return report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.

Sales Tax Analysis

To generate Sales Tax Analysis report,

Navigate to Tax Reports menu in finance module, click Sales Tax Analysis to open report page.
In calendar field, click to select date range to generate sales tax analysis.
Click search icon, the Sales Tax Analysis report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.

Receipt Tax Analysis

To generate Receipt Tax Analysis report,

Navigate to Tax Reports menu in finance module, click Receipt Tax Analysis to open report page.
In calendar field, click to select date range to generate receipt tax analysis.
Click search icon, the Receipt Tax Analysis report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.

Purchase Tax Analysis

To generate Purchase Tax Analysis report,

Navigate to Tax Reports menu in finance module, click Purchase Tax Analysis to open report page.
In calendar field, click to select date range to generate purchase tax analysis.
Click search icon, the Purchase Tax Analysis report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.

Payment Tax Analysis

To generate Payment Tax Analysis report,

Navigate to Tax Reports menu in finance module, click Payment Tax Analysis to open report page.
In calendar field, click to select date range to generate payment tax analysis.
Click search icon, the Payment Tax Analysis report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.

Journal Tax Analysis

To generate Journal Tax Analysis report,

Navigate to Tax Reports menu in finance module, click Journal Tax Analysis to open report page.
In calendar field, click to select date range to generate journal tax analysis.
Click search icon, the Journal Tax Analysis report for selected period will show in screen, click to download report in xlsx format, click to download report in PDF format.