n8n-nodes-usage-billing

This n8n community node provides usage-based billing calculation functionality. It takes usage data and price lists as inputs, performs matching and calculation, and outputs formatted billing records.

IMPORTANT: When updating between versions, make sure to restart your n8n instance after the update. UI changes and new features are only picked up after a restart.

This n8n community node provides usage-based billing calculation functionality. It takes usage data and price lists as inputs, performs matching and calculation, and outputs formatted billing records.

Installation Features Operations Configuration Options Contributing Support License

Features

• CSV Price List Import: Convert CSV price lists to structured JSON data
• Flexible Usage Matching: Match usage data to price list items using multiple fields
• Customer-Specific Pricing: Support for customer-specific pricing rules
• Calculation Options: Configure rounding and decimal precision
• Output Customization: Control which fields appear in the output
• Usage Summarization: Generate summaries by grouping and totaling fields

Operations

The node provides three main operations:

Import Pricing Data

Convert CSV pricing data to structured JSON:

1. Provide CSV data in an input field
2. Configure CSV parsing settings (delimiter, field mappings)
3. Get structured price list as JSON output

Match Usage and Calculate

Match usage data with pricing records and calculate costs:

1. Provide price list and usage data in specified fields
2. Configure match fields (productId, region, etc.)
3. Configure calculation options (quantity field, price fields, rounding)
4. Configure customer-specific pricing (if needed)
5. Configure output field options
6. Get calculated billing records as output, with unmatched records in a separate output

Usage Summary

Generate summaries of usage and costs:

1. Provide calculated billing records as input
2. Specify fields to total (cost, price, etc.)
3. Specify fields to group by (date, customer, product, etc.)
4. Get summarized totals as output

Configuration Options

Import Pricing Data Configuration

• CSV Parsing Configuration: Field name containing CSV, delimiter options
• Column Filtering Options: Include all columns or specify columns to include

Match Usage and Calculate Configuration

• Price List Field: Field containing price list data
• Usage Data Field: Field containing usage data
• Match Fields: Field pairs to match between price list and usage data
• Calculation Configuration: Fields and options for calculation
• Customer-Specific Pricing: Options for customer-specific price entries
• Output Fields Configuration: Control which fields to include in output

Usage Summary Configuration

• Fields to Total: Comma-separated list of fields to sum
• Group By Fields: Fields to group by when generating summaries
• Include Source Data: Option to include source records in summary

Contributing

Contributions are welcome! If you'd like to contribute to this project:

1. Fork the repository
2. Create a feature branch (git checkout -b feature/AmazingFeature)
3. Commit your changes (git commit -m 'Add some AmazingFeature')
4. Push to the branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

Support

If you find this node helpful and would like to support its development:

License

MIT