For step-by-step instructions on creating templates, see our individual template guides: Orders, Revenue Recognition, Cancellations, Cash Receipts, Gift Cards.
Group By Options
Group By controls how your journal entry data is organized. The available options vary by journal entry type.
Group By Option | Orders | Cancellations | Revenue Recognition | Cash Receipt | Gift Cards |
Order System | ✅ | ✅ | ✅ | — | ✅ |
Order System Account | ✅ | ✅ | ✅ | ✅ | ✅ |
Channel | ✅ | ✅ | ✅ | ✅ | ✅ |
Location | ✅ | ✅ | ✅ | ✅ | ✅ |
SKU | — | — | ✅ | — | — |
Product Title | — | — | ✅ | — | — |
Payment System | — | — | — | ✅ | — |
Payment System Account | — | — | — | ✅ | — |
Key differences to note:
Cash Receipts use Payment System / Payment System Account instead of Order System / Order System Account, since cash receipts are grouped by payment processor rather than order platform
SKU and Product Title are only available for Revenue Recognition
Channel and Location are available across all journal entry types
Filter Options
Filters let you narrow down exactly what data is included in a template. Each filter supports "is" and "is not" logic, so you can include or exclude specific values.
Filter Option | Orders | Cancellations | Revenue Recognition | Cash Receipt | Gift Cards |
Channels | ✅ | ✅ | ✅ | ✅ | ✅ |
Locations | ✅ | ✅ | ✅ | ✅ | ✅ |
Order System | ✅ | ✅ | ✅ | — | ✅ |
Order System Account | ✅ | ✅ | ✅ | — | ✅ |
Order Tags | ✅ | ✅ | ✅ | ✅ | ✅ |
State | ✅ | ✅ | ✅ | — | — |
Country | ✅ | — | ✅ | — | — |
Discount Codes | ✅ | ✅ | ✅ | — | ✅ |
Fulfillment Location | — | — | ✅ | — | — |
SKU | — | ✅ | ✅ | — | — |
Product Title | — | ✅ | ✅ | — | — |
Payment System | — | — | — | ✅ | — |
Payment System Account | — | — | — | ✅ | — |
Key differences to note:
Cash Receipts use Payment System / Payment System Account filters instead of Order System filters
Fulfillment Location is only available for Revenue Recognition (since rev rec is fulfillment-based)
SKU and Product Title filters are available for Revenue Recognition and Cancellations
Country is available for Orders and Revenue Recognition only
State is available for Orders, Cancellations, and Revenue Recognition
Common Template Configurations
Here are some of the most common ways customers set up their templates:
Single platform, all data:
Group By: Order System | Filter: Order System = Shopify
Separate templates per store:
Group By: Order System Account | Filter: Order System Account = [specific store name]
Channel-specific template (e.g., subscriptions only):
Group By: Channel | Filter: Channel = Subscriptions, Order System = Shopify
Cash receipts by payment processor:
Group By: Payment System Account | Filter: Payment System Account is not Amazon
Revenue recognition by SKU:
Group By: SKU | Filter: None (or filtered by specific channel/location)
Tips
You can combine multiple filters on a single template to get exactly the data you need
Use "is not" logic when it's easier to exclude one value than select many (e.g., "Payment System Account is not Amazon" instead of selecting every Shopify payment account individually)
Most customers start with Order System or Order System Account as their default grouping and adjust from there based on their reporting needs
If you're unsure how to structure your templates, we recommend starting with the Interactive Explorer to preview different groupings and filters before saving them as templates
Have questions about which configuration is right for your setup? Reach out to our Customer Success team for assistance.