Costing & FinanceFree worksheetPDF, Excel, Word export

Weekly Backlog and Bookings Report Worksheet

Backlog and bookings tell you whether demand is outrunning capacity. This worksheet rolls opening backlog, bookings and shipments forward each week and shows book-to-bill and weeks of backlog.

Download:

Closing backlog	Book-to-bill	Weeks of backlog
$3,260,000	1.125	6.7917
$3,150,000	0.7885	6.0577
$3,335,000	1.3663	6.604
$3,220,000	0.7677	6.5051

Total bookings

$2,020,000

Total shipments

$2,000,000

Period book-to-bill

1.01

Average weekly shipments

$500,000

Enter each week's opening backlog from the previous closing figure. Use consistent definitions: bookings are new firm orders and changes, shipments are invoiced or shipped value. Exclude forecast and quotes.

Automate the Monday backlog roll-forward

Optional expert review of pulling bookings, shipments and backlog directly from your ERP with a visible query.

Optional. The tool and every export work without this. No spam.

How to use it

Pull open order value at the start of the week from your ERP, then add that week's new firm bookings and shipments. Closing backlog is opening plus bookings minus shipments. Enter next week's opening as this week's closing and check it ties to the ERP open order report; a mismatch usually means cancellations, price changes or scope edits that were not booked. Export the table to Excel or PDF for the weekly review.

Reading the ratios

Book-to-bill is bookings divided by shipments. Above 1.0, backlog is growing; below 1.0, it is shrinking. Weeks of backlog divides closing backlog by recent shipments and shows how long current capacity would need to clear the order book. One week is noisy, so judge the trend over four to eight weeks.

Book-to-bill above 1.1 for many weeks: check capacity and lead time promises
Below 0.9 for many weeks: check pipeline and pricing
Rising weeks of backlog with flat shipments: customers will see longer lead times

Common mistakes

Do not mix currencies without a stated rate. Do not count blanket order totals as bookings; count releases or firm schedules. Make sure cancellations and returns are reflected as negative bookings or a separate adjustment line, or backlog will drift upward. Compare backlog to your own definition of firm, for example orders within a lead-time window, rather than long-dated contract value that cannot be built yet.

Frequently Asked Questions

What is a good book-to-bill ratio?

Around 1.0 means demand and output are balanced. Above 1.0 indicates growth in the order book; below 1.0 indicates a shrinking one. What is good depends on capacity and strategy, so watch the trend more than one reading.

Should backlog include blanket orders?

Usually only the firm releases or scheduled quantities, not the full contract value. Define the rule once and apply it every week, otherwise backlog will swing with contract renewals.

How do I handle cancellations?

Record them as negative bookings or a separate adjustment so closing backlog still ties to the ERP. Review the cancellations separately for cause.

Do weeks of backlog use shipments or capacity?

This worksheet uses weekly shipments. Some plants divide by planned capacity in value terms instead. Either works if you use the same basis every week.

If weekly backlog reporting means re-exporting open orders each Monday, Netray can help automate it from your ERP, read-only and on your own infrastructure.

Talk to an Expert Explore More Free Tools

Related Tools

Discrete Manufacturing

More Costing & Finance tools

See all

Back to All Tools