Backdated Transactions
Learn how to log past transactions in your ledger
Overview
The effective_date
feature is a critical functionality in financial systems that allows recording transactions with a financial date different from their system entry date.
This capability ensures seamless migration, accurate financial reporting, reconciliation, and historical balance calculations.
Effective date vs created date
When effective_date
isn’t specified, the system automatically uses the created date as the effective date.
created_at
: Timestamp of when the transaction was recorded in the system.effective_date
: The actual financial date when the transaction occurred
Create transaction with effective date
Call the Record Transaction endpoint:
Use the effective_date
field (optional, string) to specify the date a transaction financially occurred, formatted in ISO 8601 (e.g., “2023-01-15T10:30:00Z”).
If left blank, the system will automatically use the current timestamp.
Balance calculations
In this section, you’ll learn how this affects how balances calculated.
Current Running Balance
- Backdated transactions immediately update the current running balance.
- The running balance always reflects the most up-to-date financial position based on all known transactions.
Example
- Current balance before backdated transaction:
$500
. - Record a
$200
transaction with aneffective_date
from last month. - Current balance after:
$700
.
Historical Balance Queries
When querying a balance at a specific point in time, the system:
- Starts with the most recent snapshot before the requested time
- Applies all transactions with an
effective_date
on or before the requested time - Ignores transactions with an
effective_date
after the requested time
In this example historical balance calculation includes:
- All transactions with
effective_date
on or before March 1st, 2025. - Transactions recorded after March 1st are included if their effective date is on or before that date.
Historical balances
Learn how to use historical balances.
Common use cases
Here are some use cases for backdating transactions:
- Late-arriving transactions: Record transactions that occurred in the past but were discovered later, ensuring historical accuracy with backdated entries.
- Month-end reconciliation: Attribute transactions to the correct fiscal period by backdating them, maintaining accurate financial records for period-end reporting.
- Financial reporting: Generate precise reports for specific time periods by backdating transactions to reflect their true financial occurrence, improving data integrity.
- Audit compliance: Maintain historically accurate records for auditing purposes by backdating transactions, ensuring compliance with regulatory requirements.
- Error correction: Rectify mistakes or omissions in past records by backdating transactions to their original dates, preserving ledger accuracy. See also: Adjusting Balances →.
- Historical analysis: Support retrospective financial analysis or trend tracking by backdating transactions, enabling accurate insights into past performance.
Best practices & constraints
Important Considerations
- Backdated transactions immediately impact the running balance.
- The
effective_date
:- Can be in the past.
- Must not be in the future. Use
scheduled_for
instead to schedule transactions in the future. Learn how: Scheduling Transactions →. - Defaults to the current system time if not specified.
Error Handling
Invalid effective date error:
Need help?
We are very happy to help you make the most of Blnk, regardless of whether it is your first time or you are switching from another tool.
To ask questions or discuss issues, please contact us or join our Discord community.
Connect your Blnk Ledger and explore advanced features (access control & collaboration, anomaly detection, secure storage & file management, etc.) in one intuitive dashboard.