BillQuick Report Book - BQE Software

REPORT BOOKBillQuick Report BookPurposeTo provide managers and accounting staff with financial information such as income, costs, expenses andresulting profit or loss—on accrual basis of accounting.DescriptionThe report provides a profit or loss summary for your company following accrual basis of accounting andshould be run quarterly. It summarizes your income and expenses for the selected period, includingsubtotals for each account in your chart of accounts. The last line shows your net income (or loss) for thespecified period. You can drill down further to see the details.CalculationsIt involves the following calculations:Net Income (Total Income - Cost of Goods Sold) - Total Expense (Total Other Income - Total OtherExpense)Gross Profit Revenue - Cost of Goods SoldYour operating profit would be Gross Profit – ExpensesKey FiltersFilters include Invoice Date, Account ID or Type, Project ID, Project Group, Employee Group, and more. Youshould run this report with the Date filters for the previous quarter or year.How to Run the ReportFrom the Report Center screen, select the Accounts Payable category, Profit & Loss—Accrual. Choose filtersor accept the defaults; then click Print or Preview. You can also access the most common A/P reports fromthe Reports menu, Accounts Payable.BillQuick Power Up Your Business(866) 945-1595 www.bqe.com info@bqe.com11

REPORT BOOKBillQuick Report BookPurchase Orders by VendorPurposeTo provide managers and accounting staff with information regarding all the purchases made from avendor.DescriptionThis report provides a list of items and services ordered from vendors for various projects. Organized byVendor ID, the report displays the number of items (expense units or service hours) ordered and receivedagainst a purchase order.Key FiltersOn the Report Center screen, you can filter by PO Number, Vendor ID, Project ID, Vendor Group, Projectgroup, and more.BillQuick Power Up Your Business(866) 945-1595 www.bqe.com info@bqe.com12

REPORT BOOKBillQuick Report BookHow to Run the ReportFrom the Reports menu, select Report Center Accounting Purchase Orders by Vendor. Choose one ormore filters or accept the defaults; then click Print or Preview. You can also run the most common purchaseorder and vendor bill reports from the Reports menu, Payments.Trial Balance – AccountBillQuick Power Up Your Business(866) 945-1595 www.bqe.com info@bqe.com13

REPORT BOOKBillQuick Report BookPurposeTo provide managers and accounting staff with financial information such as debit and credit balances ofvarious accounts—on accrual basis of accounting.DescriptionThis report displays a trial balance of your chart of accounts. It lists all the accounts along with theirbeginning balance, debit and credit amounts, and balance on accrual basis of accounting. It also shows thewrite-up/down adjustments and grand totals. Trial balance includes all A/R account balances, includinglong-term receivable.CalculationsTrial Balance A/R amount A/R Aging balance Credits (negative invoices) General Journal balance (A/Raccounts used in A/P transactions such as deposits).You can drill down further to see the details.Key FiltersFilters include Transaction Detail Date, Account ID or Type, and more.How to Run the ReportFrom the Report Center screen, select the Accounting category, Trial Balance--Account. Choose filters oraccept the defaults; then click Print or Preview. You can also access the most common accounting reportsfrom the Reports menu, Accounting.More Accounting Reports Account Activity by Tax Line: Provides information about all the accounts and their debit/creditbalances. Organized by tax line, the report displays account ID, account name and balance. You candrill down further to see the details. Balance Sheet Cash: Displays a list of assets, liabilities, and equity using accrual basis of accounting.The report also includes net income, retained earnings, and any write-up/down adjustments made.This report should be run twice a year and can be used to compare your year-wise trends. Itprovides managers, accounting staff, investors, suppliers, customers, etc. with financial information.It also helps you in closing the books at year-end. You can view it as of a certain date using the datefilters. You can drill down further to see the details.You can find out one of the most crucial ratios in any business, that is the current ratio from thisreport.BillQuick Power Up Your Business(866) 945-1595 www.bqe.com info@bqe.com14

REPORT BOOKBillQuick Report BookCurrent Ratio Current Assets / Current Liabilities Deposits Detail: Displays details about cash deposits made in BillQuick. Organized by type ofdeposit, the report lists the date of deposit, depositor whose payments were included, paymentamount, and account deposited to. It also includes the deposits made via journal entries (debit typeas well as bank related). You can drill down further to see the details. Financial Budget Details: Provides accountants and administrative staff with a comparison of theproposed budget and the previous periods’ budget amount. The report aids in determining thedifference between the new budgeted amount and previous years budgeted amount. Organizedby Account ID, the report displays account details such as, name, previous period, amount, change,% change, and memo. You can drill down further to see the details. Financial Budget vs. Actual: Provides a comparison of actual versus planned budget amount forvarious chart of accounts. The report aids in determining whether corrective action is required ornot. Organized by account ID, the report displays account details such as name, budgeted, actual,and remaining amounts. When you go over-budget on any account–or over the total budget, thereport flags it as ‘Over’. You can drill down further to see the details. General Ledger (General Ledger – Cash Basis – Extended): Displays your account activity on cashbasis of accounting over a period. Organized by the account type, the report lists all thetransactions for that account, providing details such as date, bill number, account type, classinvolved, payee, memo, debit or credit amount, and balance. You can drill down further to see thedetails. General Ledger - Cash: Displays your account activity on cash basis of accounting over a period.Organized by the account type, the report lists all the transactions for that account, providing detailsabout date, bill number, account type, class involved, debit or credit amount, and balance. You candrill down further to see the details. General Ledger – Extended: Displays your account activity on accrual basis of accounting over aperiod of time. Organized by the account type, the report lists all the transactions for that account,providing details such as date, bill number, account type, class involved, payee, memo, debit orcredit amount, and balance. You can drill down further to see the details. General Ledger (as of): Displays your account activity over a period and allows you to see a balanceforward of all your accounts. It prompts you to set the ‘As Of’ start date for the ledger (all recordsbefore this date are summarized into the Balance Forward line) and the ‘Cut-Off’ date (all recordsafter this date are excluded). Organized by type of account in your chart of accounts, the report listsall the related transactions, providing details about date, bill number, account involved, classinvolved, debit or credit amount, and balance. You can drill down further to see the details. General Ledger Summarized: Provides the accounting staff with a summary of the general ledgerBillQuick Power Up Your Business(866) 945-1595 www.bqe.com info@bqe.com15

REPORT BOOKBillQuick Report Bookon accrual basis. The report displays your account activity, listing the chart of accounts, classinvolved, debit and credit amount, running balance and grand totals. You can drill down further tosee the details. Journal Summarized: Provides the accounting staff with a summary of the journal on accrual basis.Organized by type of transaction, the report lists the journal entries with information about the typeand date of transactions, accounts debited and credited, debit or credit amount, and so on. You candrill down further to see the details. Profit & Loss – Accrual Basis Monthly: Provides a profit or loss summary for your company followingaccrual basis of accounting. The report summarizes your income, costs and expenses on a monthlybasis, including subtotals for each account. The last line shows your net income (or loss) for eachmonth. It involves the following calculations:Net Income Income Other Income - Expenses – Other Expenses - Cost of Goods SoldYou can drill down further to see the details. Profit & Loss – Accrual Basis Quarterly: Provides a profit or loss summary for your company followingaccrual basis of accounting. The report summarizes your income, costs and expenses on a quarterlybasis, including subtotals for each account. The last line shows your net income (or loss) for eachquarter. It involves the following calculations:Net Income Income Other Income - Expenses – Other Expenses - Cost of Goods SoldYou can drill down further to see the details. Profit & Loss Accrual – By Class: Provides a profit or loss summary for your company followingaccrual basis of accounting. Organized by class, the report summarizes your income and expensesfor the selected period, including subtotals for each account in your chart of accounts. The first lineshows your net income (or loss) for the specified period. It involves the following calculationsNet Income Income Other Income – Expense - Other Expense- Cost of Goods SoldYou can drill down further to see the details. Profit & Loss–Accrual Prev Year Comparison: Provides a profit or loss summary for your companyfollowing accrual basis of accounting. The report compares your income and expenses for thecurrent year and previous year, including subtotals for each account in your chart of accounts. Itshows the change in amount and percentage while the last line shows your net income (or loss) forthe two years. It involves the following calculations:Net Income Income Other Income - Expense - Other Expense - Cost of Goods SoldYou can drill down further to see the details.BillQuick Power Up Your Business(866) 945-1595 www.bqe.com info@bqe.com16

REPORT BOOKBillQuick Report Book Profit & Loss–Cash: Provides a profit or loss summary for your company following cash basis ofaccounting and should be run quarterly. You should run this report with the Date filters for theprevious quarter or year.The report summarizes your income and expenses for the selected period, including subtotals foreach account in your chart of accounts. The last line shows your net income (or loss) for thespecified period. It involves the following calculations:Net Income (Total Income - Cost of Goods Sold) - Total Expense (Total Other Income - TotalOther Expense)You can drill down further to see the details. Profit & Loss – Cash Basis Monthly: Provides a profit or loss summary for your company followingcash basis of accounting. The report summarizes your income, costs and expenses on a monthlybasis, including subtotals for each account. The last line shows your net income (or loss) for eachmonth. It involves the following calculations:Net Income Income Other Income - Expenses – Other Expenses - Cost of Goods SoldYou can drill down further to see the details. Profit & Loss – Cash Basis Previous Year Comparison : Provides a profit or loss summary for yourcompany following cash basis of accounting. The report compares your income and expenses forthe current year and previous year, including subtotals for each account in your chart of accounts. Itshows the change in amount and percentage while the last line shows your net income (or loss) forthe two years. It involves the following calculations:Net Income Income Other Income - Expense - Other Expense - Cost of Goods SoldYou can drill down further to see the details. Profit & Loss – Cash Basis Quarterly: Provides a profit or loss summary for your company followingcash basis of accounting. The report summarizes your income, costs and expenses on a quarterlybasis, including subtotals for each account. The last line shows your net income (or loss) for eachquarter. It involves the following calculations:Net Income Income Other Income - Expenses – Other Expenses - Cost of Goods SoldYou can drill down further to see the details. Profit & Loss – Cash Basis YTD Comparison: Provides a profit or loss summary for your companyfollowing cash basis of accounting. The report compares your income and expenses for the currentyear-to-date and previous year-to-date, including subtotals for each account in your chart ofaccounts. The last line shows your net income (or loss) for the two years-to-date. It involves theBillQuick Power Up Your Business(866) 945-1595 www.bqe.com info@bqe.com17

REPORT BOOKBillQuick Report Bookfollowing calculations:Net Income Income Other Income - Expense - Other Expense - Cost of Goods SoldYou can drill down further to see the details. Profit & Loss – Cash by Class: Provides a profit or loss summary for your company following cashbasis of accounting. Organized by class, the report summarizes your income and expenses for theselected period, including subtotals for each account in your chart of accounts. The first line showsyour net income (or loss) for the specified period. It involves the following calculations:Net Income Income Other Income – Expense - Other Expense- Cost of Goods SoldYou can drill down further to see the details. Purchase Order–Time & Expense Detailed: Provides details about time and expenses associatedwith purchase orders. Organized by PO number, the report lists the expense units or service hoursordered from vendors along with their projects, units, rates, and more. Purchase Order History: Provides historical information about items that have been ordered fromvendors. Organized by PO number and vendor, the report displays the details about expense unitsor service hours ordered, received and billed. Purchase Order Invoice: Provides a list of items ordered from the vendors. Organized by POnumber, the report looks like an invoice and displays the expense units or service hours orderedalong with their projects, units, rates, and more. Purchase Order List: Provides a list of items ordered from vendors. Organized by PO number, thereport displays the expense units or service hours ordered along with their rate and amount. Purchase Order Status--Received, Not Invoiced: The report provides information about the itemsthat have been received from a specific vendor but have yet to be billed to the client. Purchase Orders--Open: Displays the details of open purchase orders. The report lists thosepurchase orders for which items have yet to be received. Purchase Orders--Unbilled: Provides information about unbilled items on purchase orders. Thereport displays details such as vendor, associated client, receipt date and order status. Purchase Orders Received Details (Purchase Orders Received – Line Item Detail): Provides a list ofitems that have been purchased from vendors. Organized by vendor and purchase order number,the report displays information such as units received, their rates, and total amount paid. It alsodisplays the Project ID against each purchase order and vendor bill number, if the items have beenreceived.BillQuick Power Up Your Business(866) 945-1595 www.bqe.com info@bqe.com18

REPORT BOOKBillQuick Report Book Purchase Orders Received–Detail: Provides a list of items that have been ordered from vendors forprojects. Organized by purchase order number, the report displays information about expenseunits or service hours ordered, received and items remaining. Reconciliation Discrepancies: Provides details of your bank account showing how you reconciled anaccount for a previous reconciliation period. This can help you track down discrepancies with yourbank statement. The report lists the totals along with the account details like name, type, reconciledamount, type of change and effect of change. You can drill down further to see the details. Statement of Cash Flows: Provides information about cash generated and used during a specifictime interval. It provides managers, accounting staff, investors, suppliers, customers, etc. withfinancial information. The report displays the cash flow involved in operating and other financialactivities, net income generated and net cash flow for that period. You can drill down further to seethe details. Transaction Detail - Account: Provides management and accounting staff with a summary of thegeneral ledger on accrual basis. Organized by type of account, the report shows the journal entries:transaction dates, memos, debit or credit amounts, and running balances. It lists individualtransactions subtotaled by each account on your chart of accounts. When the credit amount is morethan the debit amount, the balance is displayed in red. You can drill down further to see the details. Transaction Detail Account - Cash: Provides management and accounting staff with details about various accounts and related transactions oncash basis of accounting. Organized by account type, the report shows transaction dates, memos,debit or credit amounts, and balances. It lists individual transactions subtotaled by each account onyour chart of accounts. You can drill down further to see the details. Transaction List–Date: Provides a chronological listing of all the transactions made in your company.Organized by date, the report displays details such as type of transactions, payees, accountsinvolved, date and amounts. You can drill down further to see the details. Transaction List–Vendor: Provides a listing of all the vendor-related transactions made in yourcompany. Organized by vendor, the report displays details such as type of transactions, dates,payees, accounts involved and amounts. You can drill down further to see the details. Transaction List Date - Cash: Provides a chronological listing of all the transactions made in yourcompany on cash basis of accounting. Organized by date, the report displays details such as type oftransaction, accounts involved, and debit or credit amounts. You can drill down further to see thedetails. Transferred Funds: Provides information about funds transferred between

BillQuick contains more than 500 reports and 180 invoice templates. BillQuick reports are created using Crystal Reports 2012 .NET Engine. Many reports are accessed directly from the Reports menu or BillQuick screens, while all BillQuick reports–including any reports you customize or