Articles
How to Create and Manage Invoices and Receipts in Gridlex Sky?
Management of invoices and receipts plays a crucial role for any organization. An invoice is a document that indicates the goods/services that a company has provided to a customer. Invoices also itemize the goods or services sold and may include discounts, taxes, and other fees. A receipt is a document that proves that a customer has paid for the goods/services that they have received. Gridlex Sky allows users to manage their invoices and business receipts in a single place. It can help businesses to record all their sales and receipts. Gridlex Sky accounting software is a powerful tool that allows you to easily create and manage invoices and receipts. In this user manual, we will provide step-by-step instructions on how to use the software to create and manage your invoices and receipts. If you need any help with any feature, data migration of your old accounting data, questions on Chart of Accounts (COA) or anything at all, just email apps@gridlex.com, and our team of expert accountants will be here to help you. Remember, that one of Gridlex’s core values is Customer Success. We want you to be successful. How to Create Invoices and Receipts in Gridlex Sky? Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice where you want to create and manage your invoices and receipts. Step 2: Click on the "Revenue" tab in the left navigation menu. Click on the "Add Invoice/SO" button at the top of the screen. Step 3: Here, you can view different types of invoice templates. Click on the invoice template of your choice. Step 4: Enter the necessary information for the invoice, including the customer's name, invoice date and invoice due date, the items or services being invoiced, the price for each item, and add a discount if applicable. Step 5: Once you have entered all of the necessary information, click on the "Save" button to save the invoice. Users also have the option to “Save and Print” or “Save and Send Later.” Step 6: Voila! You have created a new invoice in Gridlex Sky. To manage your invoices, click on the " View Invoices" tab in the top navigation menu. Furthermore, users can select the "Receipt due" option to view the receipt. In addition, users can use the filters and search bar at the top of the screen to quickly find the invoice they are looking for. Step 7: To manage your receipts, click on the "View Receipts" tab in the top navigation menu. This will open a list of all of your receipts. You can use the filters and search bar at the top of the screen to quickly find the receipt you are looking for. To view a receipt, simply click on its row in the table. To edit a receipt, click on the "Edit" button. This will allow you to make any necessary changes to the receipt. With the Gridlex Sky accounting software, creating and managing invoices & receipts is quick and easy. By following the steps outlined in this user manual, you will be able to efficiently manage your invoicing and payment processes. Quick Tip Gridlex Sky offers a list of shortcuts for common tasks. Users can click on the “Create an invoice” tab in order to go directly to the Revenue page without having to scroll down and click on other sections.
Published | Aug. 22, 2023, 11:39 a.m.
How to Create and Pay Bills in Gridlex Sky?
With the help of Gridlex Sky accounting software, users can create, manage purchase orders/bills, and record payment against the bills. In addition, users can add vendor credits, vendor advance, refunds at one place. If you need any help with any feature, data migration of your old accounting data, questions on Chart of Accounts (COA) or anything at all, just email apps@gridlex.com, and our team of expert accountants will be here to help you. Remember, that one of Gridlex’s core values is Customer Success. We want you to be successful. Bill Creation in Gridlex Sky Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Costs” tab. Here, users can view a complete list of all the Bills/Purchase Orders. Step 2: Add Bill/PO by selecting one of the Bill Templates available. Step 3: In the Vendor Section, add/select the vendor and fill the required fields like tax related fields (if any). Fields marked with (*) are to be filled mandatorily in order to get tax reports accurately. Step 4: If the vendor currency is other than Entity’s Reporting, give the conversion rate applicable as on the date. Give the Bill Date, Bill Due date, Invoice Reference (Supplier), Is Reverse Charge Applicable and description (if any). Step 5: In the Item Section, users can add/select the Item from the drop down. Give the quantity and price per unit for the item. Fields marked with (*) are to be filled mandatorily in order to get tax reports accurately. To add multiple items in the bill, click on the “Add Item” button. Step 6: To add taxes, click on “Add Tax” and fill the Tax Line Item Name with Tax Amount. Step 7: Once done, click the “Save” button. Step 8: You have created a new Bill. In order to view a complete list, click on “View Bills/PO”. You can click on any of the Bill ID to view the details of the bill. Step 9: Here, you can edit the bill, pay due and print the bill. Bill Payments in Gridlex Sky Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Costs” tab. Click on “View Bills/PO”. Here, choose the bill to be paid and click on the “Pay Due” button. Step 2: Enter the amount or link the amount from Advances, Credit, Excess payments and Bank transactions. Verify the payment date, select the Payment Mode (Cash/ Debit/Credit Cards/ UPI/ Bank Transfer) and choose Payment Account. Step 3: You can add more taxable items to the bill by clicking on the “Add Tax” button. To make the bill payment, click on the “Save” button. Step 4: To view the complete list of payments, click on the “View Payment” tab mentioned on the top menu of the screen. Here, click on the Payment ID to view the details of the payment. Here, users can edit the payment details by clicking on the “Edit Payment” button. Quick Tip Gridlex Sky offers a list of shortcuts for common tasks. With the help of these quick shortcuts, users can easily navigate to this page without having to scroll through other sections. Click on “Create a Bill” under Costs section to create a bill in a single click.
Published | Aug. 23, 2023, 8:50 a.m.
How to Generate a Trial Balance Report in Gridlex Sky?
A trial balance is a statement that lists the ending balances in all the ledger accounts of a business as of a specific date and time. The purpose of a trial balance is to verify the equality of the debit and credit for the ledger accounts. With the help of Gridlex Sky, users can ensure that all entries made into an organization's general ledger are properly balanced. With Gridlex Sky, users can be ascertained that there is no room for arithmetical errors as the software will help to locate errors (calculation errors, error in totalling trial balance, etc). If you need any help with any feature, data migration of your old accounting data, questions on Chart of Accounts (COA) or anything at all, just email apps@gridlex.com, and our team of expert accountants will be here to help you. Remember, that one of Gridlex’s core values is Customer Success. We want you to be successful. Generate a Trial Balance Report in Gridlex Sky Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select the “By Entity” tab in the Trial Balance module. Step 2: Here, users can ensure that the debits and credits in their financial records are in balance or not. Select the date range for which you want to prepare the trial balance. For example, you can set the time period for the previous month, or previous year or customize your dates as per your business needs. Step 3: Select the Account Type head i.e., Asset, Expense, Revenue or Liability. Users can view all account types at once by selecting “All”. Once done, click on “Go” to review the balances. Note: Users can download the Trial Balance in Excel and PDF format by clicking on the “Download” button. Step 4: If you need to make any adjustments, you can do so by clicking on the relevant account and revising the required changes. Once you have verified that the balances are correct, you can save the data by clicking the "Save" button. Step 5: Here, you viewed Trial Balance Entity-wise. Gridlex Sky allows you to view Trial balance by customer, by vendor, by item, by tax-item, by center, by division and by label. Quick Tip Gridlex Sky offers a list of shortcuts for common tasks. With the help of these quick shortcuts, users can easily navigate to the Trial Balance page without having to scroll through other sections. Click on “Review your Trial Balance” under the Reports section to view and generate your trial balance in one single click.
Published | Aug. 22, 2023, 12:35 p.m.
How to Prepare Ageing Analysis Report in Gridlex Sky?
Ageing reports are financial reports that show the outstanding balances of a company's accounts receivable/payables. Gridlex Sky offers different Ageing reports such as Accounts Receivable Ageing, Accounts Payable Ageing and Inventory Ageing. With the help of these reports, you can view the total outstanding due from the customer and due to the vendor. In addition, this report can be used to follow up with customers who have outstanding receivables. The report is typically broken down into 15-Days, 30-Days, 45-days, and >45-Days categories. This will allow you to view the customers who are delinquent on their payments and by how much. Furthermore, users can view inventory ageing reports. If you need any help with any feature, data migration of your old accounting data, questions on Chart of Accounts (COA) or anything at all, just email apps@gridlex.com, and our team of expert accountants will be here to help you. Remember, that one of Gridlex’s core values is Customer Success. We want you to be successful. Inventory Reports in Gridlex Sky Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select the “Inventory Summary” option mentioned in Inventory Reports module. Step 2: Here, users can view a list of inventory items and details like the opening quantity, stock on (+ve) or (-ve), current quantity etc. Step 3: To view the details of the item, click on the item name. Users will be redirected to the Inventory List where they can view the batch added date, batch ID, available stock value, etc. Step 4: Gridlex Sky allows you to view Inventory Valuation Summary as well. To view it, go to Reports section >> Inventory Reports >> select Inventory Valuation Summary from the module. Step 5: To know more details on the item, click on the Item Name. Once you click, you can view the complete details of that particular item like batch added date, batch ID, available stock value, etc. Ageing Reports in Gridlex Sky Ageing reports are financial reports that show how long an asset or liability has been outstanding. These reports can be useful for tracking the age of accounts receivable (customer invoices that have not yet been paid) and accounts payable (bills that have not yet been paid), as well as other assets and liabilities. Accounts Receivable Ageing Accounts Receivable Ageing Report is a financial report that shows how long customer invoices have been outstanding. This report is used to track the age of accounts receivable, which are amounts that customers owe to a business for goods or services that have been delivered but not yet paid for. Users can use this feature in Gridlex Sky to identify which customer invoices are overdue and may need follow-up action. It can also be useful for identifying any trends or patterns in payment times, which can help you better manage your cash flow. Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select “Accounts Receivable Ageing” option mentioned in Ageing Reports module. Step 2: Specify filters or criteria for the report (if required), such as a specific date range. Click on “Go” to view the updated accounts receivable ageing report. Once done, download the file in PDF or Excel spreadsheet format for further analysis. Accounts Payable Ageing An accounts payable ageing report is a financial report that shows how long bills or other payments owed to vendors or suppliers have been outstanding. This report is used to track the age of accounts payable, which are amounts that a business owes to vendors or suppliers for goods or services that have been received but not yet paid for. Users can use this feature in Gridlex Sky to identify which bills or payments are overdue and may need follow-up action. It can also be useful for identifying any trends or patterns in payment times, which can help you better manage your cash flow and relationships with vendors and suppliers. Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select “Accounts Payable Ageing” option mentioned in Ageing Reports module. Step 2: Specify filters or criteria for the report (if required), such as a specific date range. Click on “Go” to view the updated accounts payable ageing report. Once done, download the file in PDF or Excel spreadsheet format for further analysis. Inventory Ageing Inventory ageing reports are financial reports that show how long inventory has been held by a business. These reports can be useful for tracking the age of inventory items, which can help businesses identify slow-moving or obsolete items that may need to be sold or discarded. Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select “Inventory Ageing” option mentioned in Ageing Reports module. Step 2: Specify filters or criteria for the report (if required), such as a specific date range. Click on “Go” to view the updated inventory ageing report. Once done, download the file in PDF or Excel spreadsheet format for further analysis. How to View Duplicate Transactions in Gridlex Sky? Step 1: Choose the entity of your choice. Go to Reports >> Banking Reports Module and click on Duplicate Statement Lines. Step 2: Here, users can view Duplicate Transactions in the statement. They can also select the account of their choice. Number Format Settings in Gridlex Sky By default, the Gridlex Sky will use the number format that is set in the system preferences of the computer. However, users can usually change the number format in the software to suit their preferences or the requirements of their business. Step 1: Choose the entity of your choice. Go to Reports >> Reports Settings and click on Number Format. Step 2: Here, you can view two options i.e. US Number Format and Indian Number Format. Change whatever is convenient and meets your business requirements. Once done, click on the “Save” button to submit the changes. Quick Tip Gridlex Sky offers a list of shortcuts for common tasks. With the help of these quick shortcuts, users can easily navigate to account receivable and account payable page without having to scroll through other sections. Click on “Review your Accounts Receivables” to directly view the data. Click on “Review your Accounts Payable” to directly view the data.
Published | Aug. 22, 2023, 12:50 p.m.
How to Prepare and Analyze Balance Sheet and Cash Flow Reports in Gridlex Sky?
The balance sheet and cash flow reports are two of the most important financial statements in accounting. The balance sheet report shows a company's assets, liabilities, and equity, while the cash flow report shows a company's cash inflows and outflows. With the help of Gridlex Sky, users can utilize these reports to capture the condition of the company's finances. Users can dive deeper in the Balance Sheet and Cash Flow Reports that can be used to make business plans for the future. Furthermore, they can export these reports in PDF format as well. If you need any help with any feature, data migration of your old accounting data, questions on Chart of Accounts (COA) or anything at all, just email apps@gridlex.com, and our team of expert accountants will be here to help you. Remember, that one of Gridlex’s core values is Customer Success. We want you to be successful. Balance Sheet Reports in Gridlex Sky Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select the “By Entity” tab in the Balance Sheet module. Step 2: Here, users can view a financial statement that shows the assets, liabilities, and equity of a business at a specific point in time. Select the date range for which you want to prepare the balance sheet. For example, you can set the time period for the previous month, previous year or customize your dates as per your business requirements. You can also customize the view of the sheet. Vertical View Horizontal View: Step 3: If you need to make any adjustments, you can do so by clicking on the relevant particulars and revising the required changes. Once you have verified that the balances are correct, you can save them by clicking the "Save" button. Step 4: Users can view and generate their balance sheet according to item-wise, center-wise, division-wise, and label-wise. Balance Sheet Reports - Schedule III Format Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select the “Schedule III” tab in the Balance Sheet module. Step 2: Enter your asset and liability accounts into the appropriate sections of the balance sheet template. Click on “Edit Account Mapping” to edit the mapping of the Account Types. Once done, click on the “Save” button. Cash Flow Reports in Gridlex Sky Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select the “By Entity” tab in the Cash Flow module. Step 2: Users will be directed to the “Entity Cash Flow” section. Here, users can view the Profit & Loss Statement for a certain period. Furthermore, users can utilize the filters to view custom time period i.e From and To Date. In addition, users can view the entire report in Vertical view and Horizontal view. To expand the section, click on (+) and to collapse click on (-). Note: Users can download the Profit & Loss Statement in Excel and PDF format by clicking on the “Download” button. Step 3: Apart from Entity Cash Flow, users can view and generate their cash flow reports by customer, by vendor, by item, by center, by division, and by label.
Published | Aug. 23, 2023, 6:47 a.m.
How to Create a Journal Entry in Gridlex Sky?
Journals are used to keep track of financial transactions. i.e., a record of all business transactions. Transactions are typically recorded in a journal before being recorded in a ledger account. With Gridlex Sky, users can develop detailed journal reports that can be used to make decisions about financial planning. They can keep a track of their debits and credits, income and expenses, money transfer, and many more. If you need any help with any feature, data migration of your old accounting data, questions on Chart of Accounts (COA) or anything at all, just email apps@gridlex.com, and our team of expert accountants will be here to help you. Remember, that one of Gridlex’s core values is Customer Success. We want you to be successful. Creation of Journal in Gridlex Sky Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Journal” section and click on “Add Transaction”. Step 2: Here, you can add a transaction by selecting one of the Transaction Templates available. For example, you can select a salary template, manual journal, vendor payment, etc. Step 3: Give the Journal Date, Journal Mode, Journal Reference, and Journal Description (if any). If the transaction currency is other than Entity’s Reporting, give the conversion rate applicable as of the date. Step 4: After that, fill in all the necessary transaction details. Select the “Debit Account” and enter the transaction amount and also enter the notes (if any). Next, Select the Credit Account and enter the transaction amount and enter the notes (if any). Once done, click on the “Save” button. Note: If the transaction had multiple Debit/Credit accounts, you could add them by clicking on the “Add Debit/Credit Transaction” and entering the amount (if any). How to View Transactions in Gridlex Sky? Step 1: To view a complete list of transactions, go to the “Journal” section and click on the “View Transactions” from the top menu. Here, users can utilize the filters to avail the transaction details more effortlessly. Step 2: To view more details like Journal Mode, Date, Reference, etc, click on the “Transaction ID”. In addition, you can edit and print the journal entry by clicking on the “Edit” and “Print” buttons present on the right side of the page. How to View Journals in Gridlex Sky? Step 1: To view a complete list of Journal Entries, go to the “Journal” section. Here, users can view a list of Journal entries. Users can also utilize the filters to avail the transaction details more effortlessly. Click on the “Transaction ID” to view more details about the journal. Note: Users can download the list of Journal Entries in Excel and PDF format by clicking on the “Download” button. Step 2: After clicking on the “Transaction ID”, users can view the complete details like the amount, currency, date, etc. Step 3: To view Audit Trail details, click on the “Audit Trail” button present next to the “Journal Details” button. Quick Tip Gridlex Sky offers a list of shortcuts for common tasks. With the help of these quick shortcuts, users can easily navigate to this page without having to scroll through other sections. Click on “Create a Manual Journal Entry / Transaction” to edit/add/view Journal or Transactions with one click.
Published | Aug. 23, 2023, 6:55 a.m.
How to View Profit & Loss Statement in Gridlex Sky?
Gridlex Sky allows users to view detailed Profit and Loss Statements that can be used to track the financial performance of a business over time. Businesses can use these reports to assess whether they are making a profit or loss and to track the total income and expenses. For example, all the business related transactions like invoices, bills, expenses, other income, etc will be recorded in the P&L statement. In addition, users can view P&L Statements in accordance with the Center, Division and Label-wise. Gridlex Sky offers Schedule - III format for the companies as per the requirement of the Companies Act, 2013. If you need any help with any feature, data migration of your old accounting data, questions on Chart of Accounts (COA) or anything at all, just email apps@gridlex.com, and our team of expert accountants will be here to help you. Remember, that one of Gridlex’s core values is Customer Success. We want you to be successful. How to View Profit & Loss Statements in Gridlex Sky? Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select “By Entity” tab. Step 2: Users will be directed to the “P&L By Account” section. Here, users can view the Profit & Loss Statement for a certain period. Furthermore, users can utilize the filters to view custom time period i.e. From and To Date. In addition, users can view the entire report in Vertical view and Horizontal view. Note: Users can download the Profit & Loss Statement in Excel and PDF format by clicking on the “Download” button. Vertical View: Horizontal view: Step 3: Go to “Dashboard” to view the Graphical Representation of the Profit and Loss. Users can also customize the period they are willing to view. In addition, this allows users to gain a visual representation of the expenses, revenue, and P&L. Step 4: Click on “Variance Analysis” to compare Period 1 with Period 2 i.e., users can compare actual financial results to a budget or forecast. With the help of variance analysis, users can identify any significant deviations from the budget or forecast. Step 5: To view complete details by account, go to Reports >> Click on By Entity (Under P&L Statement) and Click on “P&L by Account''. Here, click on any property to view the entire details. For example, Click on “Supplies and Materials - DE” to view the transaction details, transaction type, reference, credit & debit amount, etc associated with that particular property. How to View Schedule III in Gridlex Sky? Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select “Schedule III” tab. Step 2: Here, users can view the P&L Statement in Schedule - III format as per the requirement of the Companies Act, 2013. Users can use filters like Time period, filter by center, division, labels, etc to narrow their view for a specific period. Furthermore, users can edit their account mapping by clicking on the “Edit Account Mapping” present in the top right corner of the screen. Consolidated View: Detailed View: Step 3: Here, users can edit their account types, write notes and descriptions (if any). Once done, click on the “Save” button. Quick Tip Gridlex Sky offers a list of shortcuts for common tasks. With the help of these quick shortcuts, users can easily navigate to this page without having to scroll through other sections. Click on “Review your P&L” under Reports section to view the Profit and Loss Statement in a single click.
Published | Aug. 23, 2023, 6:56 a.m.