Dealing with a small discrepancy

For a particular transaction in my bank account, I’ve tagged it as a transfer to an associated internal Merchant account, and in that Merchant account I can break down the total into separate components (e.g. sales and commission) and tag those separately.

I get the values for each component (sales and commission) from raw data from the client (in spreadsheet format). Usually, these match up exactly to the overall amount actually paid into the account. But a couple of months ago, there was a very small difference (£0.16). I was hoping that the raw data for the next month would have a similar discrepancy in the opposite direction, but it didn’t, so I’m left with a very small non-zero balance in my Merchant account.

I can’t yet figure out why the discrepancy occurred. But, rather than spend hours more on this, my feeling is that because this amount is so insignificant, is there a way of just transferring it into some internal account, for “unexplained” values like this that don’t really have a material impact on anything?

Hello @drmrbrewer

You could just create a transaction for the £0.16 and tag it as “Something else not in this list” tag it to the write off code (in overheads).

Which code specifically would you suggest? Code 8100 is “bad debt write off”, which doesn’t have the right ring to it. Maybe “9999 Mispostings Account”? Or create a custom code for this? Probably doesn’t matter too much, but just trying to adopt best practice :slight_smile:

Hello @drmrbrewer

Bad debt write off 8100 is used to write off small invoice values or unrecoverable invoice debts.

That’s typically what I would suggest but feel free to create your own code in the same area of the chart of accounts.

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.