Comprehensive weather insights help safeguard your operations and drive confident decisions to make everyday mining operations as safe and efficient as possible.Top Three Problems: How to Solve End-of-Month Reconciliation Issues
When the end of the month rolls around, many accounting team members face it with a, shall we say, “less than enthusiastic” attitude. And who can blame them? Tracking down documents is inefficient, and often requires logging into a supplier portal to try to recreate them.
Let’s look at common challenges that accounting departments in downstream energy face.
- Lost bills of lading
They come in at the beginning of the month and get mis-flagged, so they end up in the wrong place. Or they’re lost altogether, requiring immense time to research and reproduce the BOL. Consider having one person be the dedicated “document dispatcher.” This expert will concentrate specifically on taking in BOLs, assigning them a “lane,” and ensuring they arrive at the correct destination. When the end of the month comes around, the accounting team can all go to the dispatcher with their requests, and she’ll know exactly where the data is. This kind of controlled access prevents the confusion of different filing and organizational systems for the same purpose.
- Supplier documents span billing cycles
The supplier portal yields documents for the entire shipment of product, but the product in question was delivered over a span of days that crosses months. This one’s a bit more difficult but could be worth the effort: consider creating a template that combines the supplier data into one document that fits your billing cycle. It still requires manual data entry, but if there’s at least a form for the data to follow, it will make the data clearer for reconciliation.
- Suppliers use different systems
When suppliers and accounting offices use different systems, this often requires data to be manually entered and converted into a format compatible with the office accounting software.This is another problem that requires manual data entry. The best approach to this problem is to allow for more time. Manually converting and re-entering data [from one format to another] is where errors occur, requiring additional time to allow for a review period. Once errors are eliminated, it’s safe to consider the data as “final,” to be included in reconciliation.
The solution
If these problems are negatively impacting your accounting productivity, DTN TIMS® Journal ID from DTN may be the solution you’re after.
DTN TIMS Journal ID automatically groups data by inventory activity period, eliminating the need to manually track and link data from different suppliers. Data is normalized into a single XML feed that flows seamlessly into your current accounting system.
With easier, more efficient reconciliation, you’ll realize revenue faster, and save employees’ time.
