Creating a report that shows a bill and the transactions linked to it

Legacy KB ID: 635

Question

How do I create a report that shows a bill and the transactions linked to it?

Answer

The report you create to view a bill and its linked transactions (for example, purchase orders, bill credits, and bill payments) will depend on whether you want to view one bill on the report, or multiple bills within a particular date range. Choose the option below that best fits your needs: If you want a report for only one bill: Find the bill in question, click the History button at the top of the form, and then in the Transaction History - Bill window, click the Print button to generate a Bill History report.

Note: The Find feature (on the Reckon Accounts Edit menu) can help in locating specific transactions. Select filters pertaining to the entry (for example, transaction type, name, and date), then click Find. Double-click the item in the results area to open the form. If you want a report that shows multiple bills:

  1. From the Reckon Accounts Reports menu, choose Banking, and then Cheque Detail.
  2. Click the Modify Report button, and then click the Header/Footer tab.
  3. In the Report Title box, type Bill Detail.
  4. Click the Filters tab, and in the Filter box, select Account.
  5. Select All accounts payable from the drop-down list.
  6. In the Include split detail? section of the Account filter, select For detail accounts matching.
  7. In the drop-down list beneath For detail accounts matching: If you are using inventory, choose Selected accounts, and then select each current asset and expense account listed, including the COGS account. If you are not using inventory, select Expense and other expense accounts.
  8. Select Amount in the Filter box, and then select the option for Any.
  9. Select Date in the Filter box, and then enter the appropriate date range.
  10. Select Transaction Type in the Filter box, and then select Bill from the drop-down list.
  11. Select Detail Level in the Filter box, and then select the option for All.
  12. Click OK. To save the modified report, click the Memorize button, and then click OK.

To access the report again, from the Reports menu, choose Memorized Reports, and then Memorized Report List. Double-click the report name to open it.

Note: If you have entered bills that post to accounts other than expense accounts (for example, COGS, income accounts, or balance sheet accounts other than Inventory Asset), then the filter in previous Step.

For detail accounts matching, should to be set to Selected accounts so you can include those "non-expense" accounts. Choose each expense account listed, as well as the "non-expense" accounts affected by the bills, then click OK. (COGS is a variable expense account and is considered different than regular expense accounts.)

Important: Because of the way the report is filtered, amounts are added multiple times and may be confusing. You may want to remove the amount columns. Click Modify Report, and on the Display tab, clear the check mark from the Columns box for each column you want to remove.


Need more help?

Ask the Reckon Community at: https://community.reckon.com/categories/reckonaccounts

Or Log a Support Ticket: https://www.reckon.com/au/support/

How did we do?

Cannot deselect columns from a Leave Accrual Summary Report

Send Forms list is blank and there are no forms to email

Related Articles

Transaction report on COGS shows some Bills when only Invoices & Sales receipts should show
Transaction Journal shows an account entry assigned to a Customer:Job
How do I generate a report that shows my customer balances?
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)