Over the last couple of years, as fiscal hosts have grown and matured, they have come to rely more closely on Open Collective for accounting and legal compliance purposes. This places more rigorous demands on the Open Collective ledger, which records all the transactions that take place on the platform. Over the last few development cycles we’ve made some updates to the ledger itself and released an updated transactions tool that gives you direct access to the ledger. The new transactions report and CSV export continue that effort.
The ledger itself, especially from a fiscal host perspective, is complex and can be challenging to navigate and understand. The new transactions report and CSV export were designed to address this.
Transaction Report
Introducing a new Transactions Report for fiscal hosts. This is a report that summarizes ledger activity for a given period of time (eg: month, quarter) and “explains” everything that happens in the ledger. The report has two parts:
Managed funds represent transactions that occur for your hosted collectives (this accounts for funds you hold on the platform on behalf of your collectives).
Operational funds represent transactions that occur for you as a fiscal host (this accounts for your organizational funds as they are represented on the platform).
In each section, you will find summarized values for contributions, expenses and fees.
All the numbers in the report are directly linked to the underlying ledger transactions making it possible for admins to better understand the report and validate it against the transactions.
We have upgraded the Transaction Export tool to make it easier to repeatedly export clear and reliable transaction data for you to process off-platform.
We’ve re-organized the fields (renamed them, added tooltips and deprecated legacy fields that were causing confusion).
We’ve created a new default export field set to reflect changes that we made to the ledger recently (transforming payment processor fees & taxes into separate transactions, improving the exported payment method information and exporting effective dates) while providing backward compatibility for users who have come to rely on the previous export format.
You can also configure and save your own export presets.
This is a very useful improvement, especially for fiscal hosts that need clearer reporting for accounting and compliance. The separation between managed funds and operational funds makes the ledger easier to understand, and linking report numbers directly to the underlying transactions is a strong step for transparency and validation.
The saved export presets also sound helpful for teams that regularly process data off-platform. Clear reporting can reduce confusion and give teams a smoother view of their finances, almost like seeing the bigger picture from a hot air balloon.
Looking forward to seeing how this develops after the public beta and how user feedback improves the reporting experience further.
This is a great improvement, especially for fiscal hosts who need more transparency and easier reconciliation of financial records. Having summarized reports that link directly to the underlying ledger transactions should save a lot of time during audits and monthly reviews. The updated CSV export and clearer field organization are also welcome changes for teams that process accounting data externally. As someone who works with digital businesses and web projects through stylojem.com, I appreciate tools that prioritize transparency, accuracy, and usability. Looking forward to seeing how these features evolve beyond the beta phase.
Mary Berry Recipes provides a wonderful collection of classic and modern dishes inspired by the renowned British chef and baking expert. From delicious cakes and desserts to family-friendly meals and simple baking ideas, these recipes help home cooks create flavorful dishes with ease. Explore Mary Berry Recipes for reliable cooking inspiration, helpful techniques, and homemade treats perfect for any occasion. Explore more details now on https://maryberryrecipeshub.co.uk/mary-berry-sticky-honey-chicken-recipe/ .
The improvements to the reporting and export tools sound useful, especially the way the report connects summarized figures back to the underlying transactions. Keeping accurate records and reviewing them regularly can make it much easier to spot issues early and stay organized.
on