Becoming Familiar with Daybooks in QAD

Posted on: August 8, 2021 | By: David Kwo | QAD Financials

Daybooks in QAD, commonly known in accounting as journals, are categorical distinctions that group general ledger transactions based on a mutual characteristic. They relate to specific menu programs that created the financial transactions, and are therefore helpful when it comes to viewing and analyzing specific types of transactions within the GL.

Daybook codes must be included in all transactions written in QAD. Though they may vary based on a company’s specific needs, within each work stream you will find daybooks for the following transactions:

Quote to Cash

  • Sales
  • Cost of Goods Sold
  • Accounts Receivable
  • Cash Settlement of Open Customer accounts

Procure to Pay

  • Purchase Order Receipts
  • Supplier Invoices
  • Supplier Payments
  • Cleared Checks

Design to Produce

  • Item Costing
  • Component Issues from Inventory
  • Parent Item receipts to inventory
  • Manufacturing Variances

Record to Report

  • Closing Journal entries
  • Foreign Currency Revaluations
  • Consolidation Transactions
  • Sales: Record all sales of merchandise on account
  • Purchase: Record all purchases of merchandise on account
  • Cash Receipts: Record all cash receipts
  • Cash Payments

Once you create and define your daybooks in QAD you can use them as sorting tools to filter reports and views on the General Ledger. Every transaction recorded in the GL must have a daybook, and there are 75-150 daybooks within QAD. The number of daybooks will vary based on your company profile whether you are a multinational org vs a single site organization.

Logan Consultants use a standard set of daybooks specific to our methodology and familiar to all of our consultants, so that we are able to provide ongoing maintenance for your QAD systems long after Logan-supported implementations.

Next Steps

If you are interested in learning more about QAD Daybooks and/or maximizing the use of your QAD system, contact us here to find out how we can help you grow your business. You can also email us at info@loganconsulting.com or call (312) 345-8810.