Generating Reports
PubCounter generates professional inventory reports for your congregation’s records and branch submissions.
Report Types
Section titled “Report Types”PDF Reports
Section titled “PDF Reports”PDF reports are formatted for printing and include:
- Kingdom Hall and congregation header
- Logo and reporting period
- Publications grouped by category
- Totals and summary information
- Generation timestamp
Best for:
- Printed records
- Physical filing
- Meeting presentations
Excel Reports
Section titled “Excel Reports”Excel reports provide data in spreadsheet format:
- One sheet per language
- All publication data with quantities
- Sortable and filterable columns
- Easy data manipulation
Best for:
- Data analysis
- Multi-language reports
- Integration with other tools
JSON Export (Pubmate)
Section titled “JSON Export (Pubmate)”JSON export is designed for Pubmate.io integration:
- Machine-readable format
- Compatible with Pubmate submission
- Includes all inventory data
Generating a Report
Section titled “Generating a Report”-
Navigate to Reports
Go to the Reports section from the main navigation.
-
Select the reporting period
Choose the month you want to generate a report for. Only periods with counted inventory are available.
-
Select languages
Choose which languages to include. You can only select languages you have permission for.
-
Choose format
Select PDF, Excel, or JSON.
-
Generate
Click “Generate Report” to create and download the file.
Report Contents
Section titled “Report Contents”Category Groupings
Section titled “Category Groupings”Reports organize publications in this order:
- Bibles
- Books
- Brochures
- Tracts
- Magazines (Watchtower, Awake!)
- Forms & Supplies
Data Included
Section titled “Data Included”Each report includes:
| Field | Description |
|---|---|
| Publication ID | JW publication code (e.g., “bh-E”) |
| Publication Name | Full title |
| Quantity | Current count |
| Status | Count status (Approved, Pending, etc.) |
| Category | Publication type |
Language Permissions
Section titled “Language Permissions”Your report options are limited to your language permissions:
- Single language - You can only generate reports for your assigned language
- Multiple languages - You can select any combination of your permitted languages
- All languages - Admins may have access to all congregation languages
Reporting Period Selection
Section titled “Reporting Period Selection”The period dropdown shows:
- Current period - The active reporting period
- Previous periods - Past periods with inventory data
- Only counted periods - Periods without data are not shown
PDF Report Layout
Section titled “PDF Report Layout”PDF reports follow a professional format:
┌─────────────────────────────────────┐│ [Logo] Kingdom Hall Name ││ Congregation Name ││ Reporting Period: Jan 2025 │├─────────────────────────────────────┤│ BIBLES ││ ─────────────────────────────────── ││ nwt-E New World Translation 15 ││ bi12-E Bible (Study Edition) 8 │├─────────────────────────────────────┤│ BOOKS ││ ─────────────────────────────────── ││ bh-E Bible Teach 24 ││ ... │├─────────────────────────────────────┤│ Generated: 2025-01-15 14:30 │└─────────────────────────────────────┘Excel Report Structure
Section titled “Excel Report Structure”Excel reports have:
- Multiple sheets - One per language selected
- Headers row - Column labels
- Data rows - One publication per row
- Formatting - Ready for printing or analysis
Best Practices
Section titled “Best Practices”Before Generating
Section titled “Before Generating”- Complete all counts - Ensure all publications are counted
- Check pending counts - Get pending counts approved first
- Verify data accuracy - Review counts before generating official reports
After Generating
Section titled “After Generating”- Review the report - Check for any obvious errors
- Save a copy - Keep records of submitted reports
- Note any issues - Document anything that needs correction
Troubleshooting
Section titled “Troubleshooting”Report won’t generate
Section titled “Report won’t generate”- Check your internet connection
- Ensure you’ve selected at least one language
- Verify you have permission for the selected languages
Missing publications
Section titled “Missing publications”- Check if the publication was counted this period
- Verify your language permissions include that publication
- Contact your admin if publications are missing
Incorrect quantities
Section titled “Incorrect quantities”- Review the original counts
- Check if counts were modified after approval
- Re-count if necessary before generating final reports
Pubmate Integration
Section titled “Pubmate Integration”For automated JW Hub submissions, see Pubmate Integration.
Next Steps
Section titled “Next Steps”- Learn about Pubmate integration for automated submissions
- Review counting inventory for accurate data