Reports > Customizing reports > Frequently used reports
In your software, there are several reports available to help you find a transaction: Account, Job, Invoice, Bill, Card, and Payroll Category. If you know the account associated with the transaction you are looking for, you can use the Account report. If you know the customer or vendor name, use the Card Transactions report. To view details about a report item, click the item in the report.
Your software contains transaction detail reports that show transactions entered for specified periods. You can use these reports as hard copy backups of your company file. These reports can be very large, so you may just want to print them at specific intervals, such as the the end of a month, quarter, or year.
Summary reports provide an overview of your business’ financial health. To help ensure the reports are accurate, enter all relevant financial transactions first, such as depreciation, interest earned, etc.
If you prepare summary reports quarterly instead of monthly, the following reports will help provide an overview of your business’ financial health for the quarter. To help ensure the reports are accurate, enter all relevant financial transactions first, such as depreciation, interest earned, etc.
At the end of a fiscal year, your accountant will need, at minimum, a Trial Balance [Summary] report, a year-end Balance Sheet, and a year-end Profit & Loss statement. You should check with your accountant before you prepare these reports, as you may need to enter some adjustment transactions.
Sales tax reporting and deposits
Use the following reports to prepare sales tax deposits and returns.
note : If you are allowed to remit sales tax on a cash basis (remit tax only on money received, not on sales booked), use the ‘Cash’ versions of the above reports.
To find out who owes you money (and for how long) you can print the Aged Receivables [Summary] report.
If you need to prepare a contact list to call late payers, print the Aged Receivables [Detail] report.
If you want to track what items (from your Items List) you sold to a customer, print the Sales [Customer Detail] report.
To analyze the profitability of a job, print the Job Statement report.
To compare how much the job is costing against the job budget, print the Jobs [Budget Analysis] report.
To find out if you have any outstanding unreimbursed expenses for the job, print the Customer Reimbursable Expenses report.
how many of a particular item you sold, print the Sales [Item Summary] report or the Sales [Item Detail] report
You can convert most reports to a spreadsheet by saving them as tab-delimited or comma separated text files. However, there are a few software reports that have been specifically designed for exporting to a spreadsheet.
In the report window, click Send To and then choose Disk. Save the report and then launch your spreadsheet and open the file. Note that the report file created by your software will not be recognized as a spreadsheet date file, so be sure to change the file type to All Files when looking for the spreadsheet report.
An amount that is a subtotal in a report shows the word ‘Total’ before the account name. Be careful to avoid double-counting the subtotals when manipulating figures in a spreadsheet.
Analyzing cash flow
|
1
|
Go to the Banking command center and click Analysis, then choose Cash Flow. The Cash Flow Worksheet appears.
|
|
1
|
|
1
|
To print the Cash Flow Analysis report, click Print at the bottom of the window.
|
Save your regular checks (telephone bill, rent, etc.) as Recurring Checks in the Spend Money window.
Analyzing income and expenses
Analyzing sales
Your software analyzes your sales four different ways: by item, by activity, by customer, and by salesperson.
