Direct Bill Ledger Accounting Key Report .ng
Direct Bill Ledger Details
Report Description: The Direct Bill Ledger Details report details all the information on accounts receivables (company name, relevant confirmation and guest details), Invoice details for invoices that have been generated, and payment type for payments that have been settled. This report can also assist with Direct Bill aging as it indicates how long the balance has been outstanding.
Date Range: One day (historical dates up to yesterday’s date)
Accounts Receivables section: provides a detailed list of transactions by company and aging group that have not been invoiced.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Company Name | Name of the local Direct Bill company (ex - John’s Bakery) | Not Applicable | Not Applicable |
Confirmation Number | Confirmation number of the reservation | Not Applicable | Not Applicable |
Guest Name | Primary guest name on the reservation | Not Applicable | Not Applicable |
Current | Current outstanding Accounts Receivable balance (0-30 days) | YES | =sum(0:30) |
Over 30 | Current outstanding Accounts Receivable balance (31-60 days) | YES | =sum(31:60) |
Over 60 | Current outstanding Accounts Receivable balance (61-90 days) | YES | =sum(61:90) |
Over 90 | Current outstanding Accounts Receivable balance (91-120 days) | YES | =sum(91:120) |
Over 120 Days | Current outstanding Accounts Receivable balance (121-150 days) | YES | =sum(121:150) |
Over 150 | Current outstanding Accounts Receivable balance (151+ days) | YES | =sum(over 150) |
Total | Total outstanding Accounts Receivable balance across all dates | YES | =sum(total) |
Invoice section: provides a detailed list of invoices by company and aging group that have not been settled.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Company Name | Name of the local Direct Bill company (ex - John’s Bakery) | Not Applicable | Not Applicable |
Invoice Number | Indicates the number that was generated for the created invoice | Not Applicable | Not Applicable |
Current | Current outstanding invoice balance (0-30 days) | YES | =sum(0:30) |
Over 30 | Current outstanding invoice balance (31-60 days) | YES | =sum(31:60) |
Over 60 | Current outstanding invoice balance (61-90 days) | YES | =sum(61:90) |
Over 90 | Current outstanding invoice balance (91-120 days) | YES | =sum(91:120) |
Over 120 Days | Current outstanding invoice balance (121-150 days) | YES | =sum(121:150) |
Over 150 | Current outstanding invoice balance (151+ days) | YES | =sum(over 150) |
Total | Total outstanding invoice balance across all dates | YES | =sum(total) |
Settlements section: provides a detailed list of applied settlements (payments) by company and aging group.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Company Name | Name of the local Direct Bill company (ex - John’s Bakery) | Not Applicable | Not Applicable |
Payment Type | For settled payments, indicates the payment type that was used (i.e. Check, Cash, Credit Card) | Not Applicable | Not Applicable |
Current | Current outstanding Accounts Receivable balance (0-30 days) | Not Applicable | =sum(0:30) |
Over 30 | Current outstanding Accounts Receivable balance (31-60 days) | Not Applicable | =sum(31:60) |
Over 60 | Current outstanding Accounts Receivable balance (61-90 days) | Not Applicable | =sum(61:90) |
Over 90 | Current outstanding Accounts Receivable balance (91-120 days) | Not Applicable | =sum(91:120) |
Over 120 Days | Current outstanding Accounts Receivable balance (121-150 days) | Not Applicable | =sum(121:150) |
Over 150 | Current outstanding Accounts Receivable balance (151+ days) | Not Applicable | =sum(over 150) |
Total | Total outstanding Accounts Receivable balance across all dates | Not Applicable | =sum(total) |
Misc Report Information:
Available Features:
Export: ability to download and save the file into an alternate format.
Filter: filter a range of data based on criteria defined by the user.
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
Grouping: ability to view the data grouped by: All or Company Name
Pie Chart: ability to view grouped data in a Pie Chart view.
Available Configuration:
User Preferences: allows the user to customize their report view by repositioning or removing columns.
Property Preferences: allows the property to customize the report view for all users by repositioning or removing columns.
Baseline Configuration:
Property Preferences Settings:
Following columns to be disabled for initial deployment:
Not Applicable