Here is an explanation of the reports provided by the Qoyod program
First: Financial Reports
1. Tax Declaration Report:
A report used to submit the tax declaration to the General Authority of Zakat and Income, reflecting details of the tax due or refundable based on daily sales and purchase invoices.
The Qoyod program provides the tax declaration report on the Reports page to submit it to the General Authority of Zakat and Income at its scheduled date, where it clarifies the tax details reflected by daily purchase and sales invoice entries on the tax declaration report, and it also includes the tax due or refundable.
In response to the General Authority of Zakat and Income’s requirements for submitting the quarterly or monthly tax declaration, the tax declaration report on the Reports page helps to know the tax details statement that the facility receives or pays, as it includes the tax due.
You can choose the period (monthly or quarterly only) in the filter options, then choose the month or quarter, and then choose the year
You can export the report to Excel or PDF below the report
2. Tax Sales Invoices Report
A report showing output tax on tax sales invoices and including details such as sequential number, invoice reference number, invoice description, customer name, tax number, issuance and due dates, invoice total, and final output tax.
This is a report required by the General Authority of Zakat and Income that clarifies the output tax on tax sales invoices created in the Sales section from the dropdown menu in Qoyod, and consists of:
- Sequential number.
- Invoice reference number.
- Invoice description.
- Customer name.
- Customer tax number.
- Issuance date.
- Due date.
- Invoice total. (including tax)
- Total tax. (shows zero if there is no tax on the invoice)
And total invoices and total final output tax.
You can specify the desired period to display all the details mentioned in the report.
The available filter options for the report are (Date “from to”, ability to exclude invoices of government customers, exclude returned invoices) only.
Notes:
The report displays all sales invoices with tax and without tax, and also displays all sales invoices even the returned ones, and if the option “exclude returned invoices” is enabled, they are excluded from the report
3. Tax Purchase Invoices Report
A report showing input tax on tax purchase invoices and including details such as sequential number, invoice reference number, invoice description, supplier name, tax number, issuance and due dates, invoice total, and final input tax, and through this report you can view purchase invoices for a specific period.
This is a report required by the General Authority of Zakat and Income that clarifies the input tax on tax purchase invoices created in the Purchases section from the dropdown menu in Qoyod, and consists of:
- Sequential number.
- Invoice reference number.
- Invoice description.
- Supplier name.
- Supplier tax number.
- Issuance date.
- Due date.
- Invoice total. (including tax)
- Total tax. (shows zero if there is no tax on the invoice)
And total invoices and total final input tax.
You can specify the desired period to display all the details mentioned in the report.
The available filter options for the report are (Date “from to”) only
4. Income Statement Report
Shows the results of the entity’s operations in terms of revenues and expenses, and determines net profit or loss. You can compare different time periods and can display details through advanced analysis and drill-down feature.
Income Statement is one of the important financial statements for any entity as it is a report that shows the results of the entity’s operations during a certain period in addition to all information related to revenues and expenses.
The main purpose of the Income Statement is to know the net profit or net loss, and the revenue and expense accounts are closed at the end of the year and are not transferred to the financial statement for the following year.
And the entrepreneur can through Qoyod compare the Income Statement to a previous period (week, month, quarter, year) while specifying the number of time periods to be compared, in addition to determining the account level desired to be displayed in the Income Statement or displaying only the account type, so the financial statements are clear to him.
You can view the Income Statement by clicking on the dropdown menu, Reports, Income Statement
- Advanced Analysis:
In the Income Statement there is an advanced analysis feature that allows you to display specific items from revenues and expenses as you wish through the “Filter” option either through additional fields that show you revenues and expenses of each item separately or through products or projects or customers or suppliers or employees and finally branches and warehouses.
And you can compare the entity’s performance between several items through the “Dimensions” option by specifying several additional fields or products or projects or several customers as well, and this helps you prepare accurate financial statements.
- Drill-down Feature (located in the top options) :
The drill-down feature allows you to review the details of the amounts that make up the amount shown in the report, such as viewing the values of each customer separately, as well as for suppliers, branches, and warehouses, products, projects, and employees, and finally documents.
5. Balance Sheet Report
Shows the financial position of the entity at a specific moment and determines the owners’ rights and liabilities. It allows comparison of performance across multiple periods with advanced analysis that allows filtering assets, liabilities, and equity.
It is one of the important financial statements when preparing the balance sheet for any entity and it shows what the entity has and what it owes at a specific moment or shows the assets of the entity and its obligations to others as it shows the rights of its owners.
This statement enables the owner of the entity to know the financial position of their entity, net capital, and know the liabilities in relation to assets, and to assess the extent of the entity’s continuity and its ability to pay its obligations.
The user can through Qoyod compare the statement of financial position for a previous period (week, month, quarter, year) while specifying the number of time periods to be compared, in addition to determining the account level desired to be displayed in the statement of financial position or displaying only the account type.
You can view the Balance Sheet “Statement of Financial Position” by clicking on the dropdown menu, Reports, Balance Sheet
-
Advanced Analysis:
In the Balance Sheet there is an advanced analysis feature that allows you to display specific items from assets, liabilities, and equity as you wish through the “Filter” option either through additional fields that show you the value of accounts of each item separately such as the statement of financial position for a specific branch or through products or projects or customers or suppliers or employees and finally branches and warehouses, and you can compare the statement of financial position between several items through the “Dimensions” option by specifying several additional fields or products or projects or several customers/suppliers as well.
6. Trial Balance Report
Shows the names of accounts appearing in the general ledger with the balance of each account and its nature (debit or credit). It helps verify the correctness of posting transactions and detect errors.
It is a statement that shows the names of accounts appearing in the general ledger and the balance of each account and its nature as debit or credit.
The main purpose of the trial balance is to ensure the correctness of posting transactions and detect errors in recording transactions through its balance and equality and giving the user a summary of the balances of all accounts at a specific moment
You can view the Trial Balance by clicking on the dropdown menu, Reports, Trial Balance.
You can specify specific accounts and values from the trial balance through “Filter” which will show you the trial balance report according to the item you wish to display such as the trial balance for customers/suppliers which shows you all accounts affected with your customer/supplier accounts, in addition to the possibility of filtering by additional fields or projects or products.
You can also choose a single account that appears for you in the trial balance by selecting the account from the dropdown menu in the available options, with the possibility of displaying detailed accounts (customers, suppliers, employees) by clicking on the feature activation toggle next to it.
- Drill-down Feature:
The drill-down feature allows you to review the details of the amounts that make up the amount shown in the report, such as viewing the values of each customer separately, as well as for suppliers, branches, and warehouses, products, projects, and employees, and finally documents.
5. General Ledger Report
Shows the movement of accounts and their balances, and serves as a control for sub-accounts, with display of details related to the debit and credit sides of accounts.
The General Ledger shows the movement of accounts and their balances from the General Journal. Each account has one or two pages. Posting to it from the General Journal is done by recording the debit parts of the entry on the debit side of the ledger in each account and the credit part on the credit side of the respective account.
This account serves as a control for sub-accounts.
It is a ledger that pertains to a single financial period only and consists of a table with 3 sides:
- Debit side which means (the one who took the debt from the creditor)
- Credit side which means (the party who has the right to an amount paid by the other party “debtor” and may be a creditor a person or institution or company or government and the creditor is the person or institution that owns the money)
- Creditor and Debtor shows what is coming in or going out of the account
For example, the inventory account: the debit side shows the amounts that entered the account. As for the credit side it shows the amounts that went out of the inventory account and it is considered the main source of information that enters the pages of the general ledger Qoyod entries in the journal ledger. Also, the net movement side shows the net amounts remaining in the account, and can be found after the calculations at the bottom of the page.
Account Balance: is the total amounts that entered the account.
When you click on display net movement for the financial year by the closing balance date, the opening balance and balance since the beginning of the year will appear
6. Journal Report:
Displays all entries that were made according to their chronological sequence or entry ID following the double-entry bookkeeping method.
It is a register in which all entries made in the program are recorded first in their chronological sequence or according to the entry ID following the double-entry bookkeeping method,
And you can see the entries for a specific document by changing the file type.
You can access it from the side menu then click on Reports then Journal.
The available filter options in the report are: Date (from to), Order by entry ID or entry date, File type (document).
The report displays all accounting entries in the system whether those that were added manually through manual accounting entries or automatic entries reflected from financial transactions.
Second: Operational Reports
1. Purchases and Sales Summary Report
Clarifies details of purchases and sales such as average purchase and sale price and available quantity with the final total, with the possibility of specifying the time period.
It is a summary of purchases and sales. It clarifies details of average purchase price, available quantity, average return value and returned quantity and final total. Similarly for sales summary which clarifies average selling price, available quantity, average return value and returned quantity and final total.
You can display the sales and purchases summary report separately i.e. sales only or purchases only or together for better comparison with specifying the required time period
And you can enable the option to display non-stocked products if you wish.
You can access it by clicking on Reports then Purchases and Sales Summary of Stocked Products and then you choose the specified time period.
The available filter options are: (Date (from to), Locations (you can choose more than one location at the same time), Party (customer or supplier – one only), Type (purchases or sales or purchases and sales), you can enable or disable the option to display non-stocked products.
You can export the report to Excel or PDF from the options at the top of the report.
2. Product Locations Report
Shows all stocked products (products, raw materials, assembled products) available in all locations (warehouses) with the total quantity, with the possibility of specifying a specific location.
Note: All product types will appear and you cannot filter by a specific type (i.e. you cannot filter raw materials only for example).
It is a report that shows the products located in all locations (warehouses) and shows the quantity of each according to the desired location and total quantity, you can choose a single location to display its quantities and import it for the necessary inventory count or to make a decision to purchase additional quantities or transfer quantities to another location.
You can access it by clicking on Reports then Product Locations Report
The available filter options are: (Locations “you can choose more than one”, selecting a specific date”)
The following data will appear: Sequential number, Product name, Location name (the quantity will appear in it), Total
3. Customer Receivables Summary Report:
Shows the amounts due from customers from pending invoices and pending credit notes, with the possibility of exporting the report to Excel or PDF.
As the report displays customer accounts from the beginning of the entity’s operation until the date added to the report and displays all customer accounts whether they have balances or their balances are zero. And if you want to filter the report you can export it to Excel and then filter the report.
It is a report that shows the amounts due from customers from pending invoice amounts or pending credit notes as well as unused collection and payment receipts and net movements of manual entries.
And you can export the report to Excel or PDF.
You can access it by clicking on Reports then Customer Debtors Accounts.
The available filter options are: selecting a specific date, enabling or disabling the option “includes performance bonds”.
The report displays the following data:
Name, Reference number, Business name, Contact number, Email, Amounts of pending invoices, Amounts of pending credit notes, Amounts of unused collection receipts.
4. Supplier Payables Summary Report:
Shows the amounts due to suppliers from pending invoices and debit notes, with the possibility of exporting the report to Excel or PDF.
It is a report that shows the amounts due to suppliers according to each supplier with the total of invoices and pending debit notes, as well as pending payment and collection receipts and net movements of manual entries and finally the net amount due so that the business owner can control the debt and arrange payments accordingly.
You can also export the report to Excel or PDF.
The available filter options are: (a specific date, ability to determine the display of all suppliers or display of suppliers with payable balances only i.e. only those who have payables).
The report displays the following data:
Name, Reference number, Business name, Contact number, Email, Amounts of pending invoices, Amounts of pending debit notes, Amounts of unused payment receipts, Amounts of unused collection receipts, Net movements of manual entries, Net amount due
5. Customer Debt Aging Report:
Shows customer debts receivable and collection payable with a chronological analysis representation that helps the business owner know the ages of invoices that have not been paid yet.
With the possibility of comparing the customer’s debt to previous periods and specifying the number of time periods to be compared and the possibility of exporting the report to a PDF file
The Customer Debt Aging Report displays receivable debts with chronological analysis based on specified comparison periods such as:
-
Weekly
-
Monthly
-
Quarterly
-
Yearly
The report does not allow dividing debts into periods such as:
-
0-30 days
-
30-90 days
-
90-180 days
You can only compare time periods according to the method of preparing the report (such as comparing month to month or quarter to quarter).
The available filter options are: a specific date, compare with (past year, past month, previous quarter, previous week), number of comparison periods (from one period to 13 periods), enable or disable the option “includes performance bonds”)
Data displayed by the report:
– Contact (party name)
– Reference number of the party
– Report date (the amounts due from customers will appear in it and next to it in parentheses the number of outstanding invoices whose status is approved or partially paid) Total
6. Supplier Debt Aging Report
Shows the amounts due to suppliers that are overdue and the number of invoices, with the possibility of exporting the report to Excel or PDF.
It is a report that shows the amounts due to the business owner that are overdue and the number of invoices and the total of all invoice amounts, so as to help know the actual time during which the business owner can pay the supplier the amounts he owes.
Once you click on the supplier’s name, all the information that the business owner needs will appear.
You can export the report in Excel or PDF format
The available filter options are: a specific date, compare with (past year, past month, previous quarter, previous week), number of comparison periods (from one period to 13 periods), enable or disable the option “includes performance bonds”)
Data displayed by the report:
– Contact (party name)
– Reference number of the party
– Report date (the amounts due to suppliers will appear in it and next to it in parentheses the number of outstanding invoices whose status is approved or partially paid) Total
7. Quotations Aging Report
Monitors open or current quotations with full details and can compare them with previous periods.
It enables the customer to monitor open or current quotations with all their details, and also allows comparing them with previous periods.
You can export the report in Excel or PDF format.
The available filter options are: a specific date, compare with (past year, past month, previous quarter, previous week), number of comparison periods (from one period to 13 periods)
Data displayed by the report:
– Contact (party name)
– Reference number of the party
– Report date (the amounts of open quotations will appear in it and next to it in parentheses the number of non-invoiced quotations) Total
8. Purchase Orders Aging Report:
Displays details of due and overdue purchase orders, with clarification of the number of purchase orders that have been converted to invoices.
A purchase order means approval to purchase before the purchases reach the entity.
Once you click on the name of the supplier with whom the purchase order was created, all the information you need will appear such as the total amount of due and overdue purchase orders and the number of purchase orders that have been converted to invoices …etc
This information will help the business owner or accountant know the actual time when they can legally demand the purchases from the supplier.
You can export the report in Excel or PDF format.
The available filter options are: a specific date, compare with (past year, past month, previous quarter, previous week), number of comparison periods (from one period to 13 periods)
Data displayed by the report:
– Contact (party name)
– Reference number of the party
– Report date (the amounts of open purchase orders will appear in it and next to it in parentheses the number of non-invoiced purchase orders) Total
9. Statement of Changes in Equity Report
This report provides a comprehensive overview of changes in the equity section of the balance sheet, allowing users to track the dynamics of equity over a specified time period.
The report summarizes changes in equity, including investments, withdrawals, and retained earnings
The report includes detailed items for the following:
- Initial equity
- Additional paid-in capital
- Withdrawals or distributions
- Net income or loss for the period
- Final equity
Third: Sales Reports
1. Product Sales Report:
A report that clarifies the sales of each product compared to the previous period whether annually, quarterly, monthly or weekly.
The benefit of this report is that it enables the business owner to know the performance of their sales and verify the effectiveness of sales strategies and discover whether they have achieved the desired results or not.
You can export the report to PDF and cannot export it to Excel.
It displays sales of each product compared to the previous period on an annual, quarterly, monthly or weekly basis, with the possibility of exporting the report to PDF.
The available filter options: (a specific date, compare with (past year, past month, previous quarter, previous week), number of comparison periods (from one period to 13 periods), you can if you wish specify the product category to display the products within this category (you can only choose one category)).
Data displayed by the report:
Product name, a column showing the date (in which the number of units sold is written), a chart showing sales)
2. Product Purchases Report
Shows purchases of each product compared to previous periods with the possibility of exporting the report to PDF.
It is a report that clarifies the purchases of each product compared to the previous period whether annually, quarterly, monthly or weekly with the possibility of specifying the number of time periods to be compared.
You can export the report to a PDF file
The available filter options: (a specific date, compare with (past year, past month, previous quarter, previous week), number of comparison periods (from one period to 13 periods), you can if you wish specify the product category to display the products within this category (you can only choose one category)).
Data displayed by the report:
Product name, a column showing the date (in which the number of units purchased is written), a chart showing purchases)
3. Product Sales Share Report
Shows the sales share of each product in relation to other products, and determines the most profitable in the specified period.
It is a report that shows the sales share of each product in relation to other products according to the specified period to identify the most profitable product.
You can export the report in PDF format.
Filter options in the report: Date (from to) and the possibility of specifying one category to focus on) if not specified it will display all categories
The report displays the following data:
Product name, Quantity, a chart showing shares.
4. New Customers Report
Displays all information related to new customers compared to previous periods with the possibility of exporting the report to PDF.
From this report, the business owner can know all the information related to new customers with the possibility of comparing them to the previous period whether annually, quarterly, monthly or weekly and specifying the number of comparison periods.
You can export the report in PDF format.
Filter options in the report: (a specific date, compare with (past year, past month, previous quarter, previous week), number of comparison periods (from one period to 13 periods)
Data displayed by the report is: Periods, Date (showing the number of customers added to the customer list until the specified date)
5. New Invoices Report
Displays sales performance through the number of invoices issued compared to previous periods with the possibility of exporting the report to PDF.
You can know sales performance through this report which displays the number of invoices issued during a specified period and compares them to previous periods.
You can export the report in PDF format.
Filter options in the report: (a specific date, compare with (past year, past month, previous quarter, previous week), number of comparison periods (from one period to 13 periods)
Data displayed by the report is: Periods, Date (showing the number of sales invoices added until the specified date)
Important note: Draft invoices are not counted as new invoices.
Fourth: Other Reports
1. User Operations Report
Shows all operations performed by the user, includes creation, modification or deletion of documents with details about the period and number of daily operations.
Important note:
If you do not see one of the reports and you are not the primary user, please contact the primary user to grant you the authority to view the required report.
It clarifies all operations performed by the user in Qoyod, where the report benefits entities that have more than one user to view all operations in addition to the days of his entry into the program and the number of hours of work on the program and the number of operations created in a day.
You can search by:
- Document: such as a purchase invoice or debit note or additional fields or settings and others.
- User: the name of the user for whom the report is to be displayed is specified.
- Operation: type of operation: create, modify or delete.
- Period: the desired period is specified (from, to)
And specify the number of operations you want to display on a single page. And click on the search icon.
You can see operation details when clicking on the “View” icon.
