Skip to main content

Sales & Slab Date Logic

Learn how G.J. Software handles Sale and Slab dates. This guide explains automatic triggers, the difference between Event and Reported dates, and the four rules that lock reporting on the 7th of each month for consistent financial tracking.

Written by Patrick Haley
Updated this week

This article explains how sale and slab dates are recorded in G.J. Software and how the system locks these dates for official reporting.

Understanding the difference between an Event Date and a Reported Date is essential for accurate business tracking and financial consistency.


The Difference Between Event Dates and Reported Dates

There are two types of dates tracked for every major milestone:

  1. Event Date (Sale/Slab Date): This is the actual day the event occurred (e.g., the day a deposit hit Xero or a slab was poured).

  2. Reported Date: This is the date used for official G.J. Gardner reporting, rankings, and financial locking. This date ensures our reports remain stable and consistent even if someone goes back and edits an old date in Xero.


Sale Date Triggers

A sale is automatically recorded in the system when the first of any of these conditions are met:

  • An overpayment is recorded against the job in Xero.

  • A contract date is added and saved in the Job Details.

  • The first payment of a claim / draw is made in Xero.


Slab Date Triggers

Slab dates use a "first trigger wins" approach. The system will record the slab date based on whichever of these events occurs first:

  1. Critical Path Stage Completion: The day all tasks are marked as Done in the schedule stage designated as "Slab."

  2. Council Permit Date: If this option is enabled in your office system variables.

  3. First Cost Center Completion: The completion date of a specific cost center task in the schedule nominated in your system variables.

  4. Claim / Draw Threshold: When 15% of the total contract value is claimed.

Note: A slab date will never trigger if the contract amount is less than $25,000.


The 7th of the Month Cutoff

On the 7th of every month, the system "locks" the previous month's data. This creates a stable snapshot for reporting purposes. Any sales or slabs entered or corrected after the 7th are handled by the reporting rules below.


The Four Reporting Rules

The system applies these rules automatically to determine the official Reported Date for any new sale or slab.

Visualizing the Reporting Windows

Rather than a simple timeline, the system uses a "Gate" logic on the 7th of each month. Use the matrix below to see where your sale will land based on when you enter the data.

If the Sale happened...

And you enter it...

The Reported Date will be...

Last Month

Before the 7th

The actual Sale Date (Last Month)

Two+ Months Ago

Before the 7th

The last day of Last Month

Anytime in the Past

After the 7th

Today's Date (Current Month)

This Month

Anytime

The actual Sale Date (This Month)

If you are entering data BEFORE the 7th of the month:

Rule 1 (Current/Future Sales)

If the event date is in the previous month or later, the system uses the actual event date.

Rule 2 (Late/Backdated Sales):

If the event date is before the previous month, the system uses the last day of the previous month. This ensures the sale is captured in the most recent open reporting period.

If you are entering data ON OR AFTER the 7th of the month:

Rule 3 (Late/Backdated Sales)

If the event date is before the current month, the system uses the current date. Since the previous month is already locked, this ensures you get credit for the sale in the current active month.

Rule 4 (Current Month Sales)

If the event date is in the current month, the system uses the actual event date.


Why This Matters

These reported dates are used to calculate Continuing Franchise Fees (CFF) and performance rankings. Once a reported date is locked, changing the underlying event date will not change the reported date. This ensures that once a month is "closed," our historical data remains accurate and reliable for everyone in the network.


Managing System Configuration and Visibility

The system provides several ways to monitor and adjust how these dates are handled for your office.

Adjusting Slab Triggers

You can choose which slab triggers are active for your office by navigating to Setup > System Variables > Jobs. From here, you can enable or disable the specific triggers (such as Council Permit or Cost Center completion) that best reflect your local build process.


Tracking Dates in the Builder Portal

Both the Event Date and the Reported Date are visible in the Jobs List and Contracts Manager. Franchisor users can also find them within the Billing tab of any individual job. For faster tracking, these dates are available as filters in your jobs list, allowing you to quickly see which sales or slabs have been officially recorded for a specific period. The dates available are:

  • Sales Date

  • Reported Sales Date

  • Slab Date

  • Reported Slab Date

Did this answer your question?