Handling Rounding Accounting

V5 Question
1

So after 72 days my work period is closed (for the 1st time)! Yah, go me but who is counting right?
Here is my Tile display which shows 0.03 cents in rounding:

The code used in Navigation is:

<size 50><bold>Tickets</bold></size>
Total Tickets: [=TN('{REPORT TICKET COUNT}')]
Total Orders: [=TN('{REPORT ORDER COUNT: }')]
[=(TN('{REPORT TICKET COUNT:(TS.Status=Unpaid)}') > 0 ? '<linebreak/><italic>Open Tickets:</italic> ' + TN('{REPORT TICKET COUNT:(TS.Status=Unpaid)}') : '')]
[=(TN('{ACCOUNT TOTAL:Receivables}') > 0 ? '<italic>Unpaid:</italic> ' + F(TN('{ACCOUNT TOTAL:Receivables}'),'0.00') : '')]

Questions:
So how do I clear the Receivables Account? Here is the ledger last few records:

ReceivableBalance.JPG916Ă—182 40 KB

Following the tutorials I have set the Account up this way and I was wondering how the “wash up” would go. Here is the Rounding Account Type setup:

So what is the process to clear the balance of the Receivables that went to Rounding?
Or should the Account Type Source Account be altered to itself? All my rounding always goes up so yes there will be a balance accrued in favour of the Club but all these transactions are paid so why is it still a receivable?.

Thanks Paul.

2

It should go into receivables and then from receivables go into rounding.

So you have it set correctly. The Transaction type your showing is what moves it from Receivables to Rounding. So that’s not the reason for the .03 something else is. I cant tell by just the screenshots you provided though.

EDIT: Ok I see what it is. You have a payment for .03 so something is wrong with your rounding calculation. Your making customer pay for the rounding twice.

Can you show your calculation type for the rounding? Also show more details of that account screen. I dont see the rounding portion of it.

3

Go to Manage > Accounts > Transactions and pull up the transaction with the .03 and show the details of that.

4

Do not think it is that as it is a running balance. I will post the summary and then the history you will see the balance constantly changes.

Receivables.JPG955Ă—472 53.7 KB

History coming:

ReceivablesHistory.JPG921Ă—1194 213 KB

The first transaction is where I INTRODUCED rounding.

Ok as always you may be onto something, as this transaction does not look right?

Trans1.JPG1128Ă—749 70 KB

5

So you had a payment transaction for 2.02 that left a balance of -0.01 Are you saying thats the first transaction where this started?

6

Looks like a Tax Template or Calculation Type is setup wrong. Show your calculation type for rounding. That transaction did not have rounding in it though right?

Can you go to Manage > Accounts > Transactions and pull up that transaction and show us?

7

No taxes at this stage? Cannot pay this bill off the only thing is VIP discounts?

8

This is the ticket:

Ummm Grand Total 2.03 but it changes to 2.02 on the payment page…

9

Can you please go to Manage > Accounts > transactions and show us that transaction it gives better idea.

10

Opps sorry! -

TransLedger21.JPG982Ă—274 42.1 KB

Ok it seem it might just be my data I guess? If that is the case can I se “Add Line” to dispose of the error or adjust the $2.03 to 2.02?

11

Its only that one transaction thats off?

12

Yes the VIP stuff did not really change once it was implemented. Like customers did not change level or rates did not change during testing. So the best way to fix this how as described above?
EDIT:
I mean I will just fix the 2/3 sales and move on as the rest of the history looks fine. I will need to check but I think it may be 3 sales.

13

Yes but if we dont find out the culpret it will keep doing it. Give me a minute while i research something I think this came up before.

14

Would you be willing to PM me a backup of your database?

15

Yes sure send you a backup I took last night.
Tickets #14,#21,#23 are suspect so far.

Ok so what I have done is use Manage -> Accounts ->Transactions and edited the ReceivableValue down 1 cent on all 3 transactions. Now I have nothing outstanding on my tile. The interesting thing is all transactions were for the same value.
The only concern is #14 as it still has a balance of 23 cents…

16

Alright then, now back to my original thought. How do we handle the “Round Account” balance at the end of the year as shown below:

RoundLedger.JPG942Ă—356 46.4 KB

So these are legitimate balances (I think) where I have now implemented a only “Round Up” calculation Auto Rounding . So I assume at the Y/End we need to journal out the 2cent Credit to INCOME? Cannot find any links handling this so far.
Thanks.

17

Ok well the fix is simple. go to your GST tax template and set Rounding to 2. To fix the balance you need to create a new account called Balance Fix or whatever you want to name it and transfer the difference to it to start fresh

18

I am positive GST was added late in the addition after these transactions? But you are absolutely right as my template is set to 0!
Just as a side note: Sort of like elevator music but on my other 24 in screen I have 8 TABs of SambaPOS open and it nothing like having kendash popup over and over again on all 8 sessions! lol :laughing: kendash has replied to your …

19

Let me show you how to do the correction. One minute.

20

OK import this to create the correction account. Then simply go to your Accounts screen click on Corrections Accounts and then execute the correction to fix the balance… so if its showing a balance of (0.03) run a correction for 0.03

Correction Account.zip (764 Bytes)