kimpossible
Experienced User
Joined 7 years ago
User Profile
User Widgets
Contributions
Sort of Transaction Per Date and Per ID Number
Hi everyone, We prepared our first set of year-end journal entries. However, we added a second set of journal entries. When we tried to print the general ledger detail of the accounts affected, the 2nd set was presented on top of the 1st set. Note that our Sorting Category is already by Date and by ID number. Pls refer to the attached sample of the ledger of the affected accounts. Why the transactions were arranged that way and what will be the best solution for this? Our goal is the present items based on date and ID number.384Views0likes1CommentRe: Approval of Payments
Hi Tracey, This is well noted. And I accepted this as Solution to my inquiry. Nevertheless, may I suggest if MYOB could create a facility which caters to printing the "Bill", not through Purchase Order Format? Specifically, same fields displayed for spend money under banking. In this way, users will have chance to record transactions prior to processing the payment (pay bill). Would very much appreciate your help on this. Thank you.843Views0likes0CommentsRe: Approval of Payments
Hi Tracey, Your response is much appreciated. For purchase transaction, 1. I created a Bill and I saw that this is posted right away in the books (meaning debit expense or fixed assets & credit to Trade Creditors); 2. I am trying to print the Bill entry; however, the only option when printing is Purchase Order; 3. When I explored the customize PO format, the table doesn't allow the display of account codes used for posting; this is the one that we would like to show. 4. The intention is, the bill should be the form to document preparation, checking and approval. 5. Pay Bill will be the entry to record payment (debit Trade Creditors & credit cash in bank); Hope this clarifies my concern.860Views0likes2CommentsApproval of Payments
Hi, Question 1: We usually encode all payment transactions through Spend Money function. However, once it is encoded by the staff, it is directly posted to the books. Is there a way to suspend posting and have an approver tick it prior to posting? Questions 2: I also tried using the Bill under Purchases. In the process of creating the form, I noted that we cannot add the field which displays the account code. Is there a way to display? Would appreciate your help on this. Thank you.Solved963Views0likes4CommentsRe: Receivables Reconciliation [Summary] - out of balance
Hi Mike_James , I repeated the steps of my correcting entries and when I generated, no out of balance in the receceivables recon and statement of account table. However, we still have this negative balance reflecting in the statement. I have attached a screenshot of the statement. table is not equal to the summary below. Note that the converted order with error amounted to 825. However, the negative balance in the aging presented is 1361. Is there a way to trace where 1361 came from? Your help is ver much appreciated. Thank you! Thank you.932Views0likes1CommentRe: Receivables Reconciliation [Summary] - out of balance
Hi Mike_James , Thank you for responding. Okay, will not reverse of delete corrections made at the moment. Our file is not online (no subscription). Could the aging issues be corrected by changing the due dates on the transactions involved? - Could you elaborate on this pls? One of my trials involved: 1. I deleted all the correcting entries 2. Created an invoice at the future date 3. Applied the deposit (the one dated 2222) to it. 4. Then I set up another deposit at the current date and applied it to the current invoice. All entries here resulted to: - GL balances are okay - Error in the table of activity statement - Error in the aging details below the statement. Pls bear with me on this. We encountered the same error last year and we did the same correcting entries but it is the first time to encounter this.935Views0likes2CommentsRe: Receivables Reconciliation [Summary] - out of balance
Hi Mike_James , All balances are tied up after all the correcting entries I made. The error in the out of balance is not in the general ledger anymore. It is in the receivables amount presented for such client. Also, I just noticed, the activity statement of account reflected correct balances for the client, but the aging details below the statement (current, previos month and prior months classification), has an error. There is a negative balance in the prior months portion showing negative balance. Would it be better if I reverse first all entries made for correction for better analysis? Hope you can help me on this. I tried several approaches and receivables out of balances can be eliminted; however, the activity statement aging portion is still showing the negative portion in the prior month. Currently, I am not able to determine the composition of the negative portion showing in the aging but this might be connected to the error in deposit application as the deposit was initially recorded in 2021 and was converted to invoice using 2222 date. Your responses are greatly appreciated. -Kim998Views0likes5CommentsRe: Receivables Reconciliation [Summary] - out of balance
Hi Mike_James , Yes, it is related to that. My staff accidentally encoded 31/08/2222 upon convert to invoice phase. To clear out the floating amount in the deposit and trade debtors, we did the following: 1. Create a credit note [negative sales invoice] using client deposit instead of income account - dated 31/08/2022 2. Create a normal invoice using client deposit instead if income account - dated 31/08/2222 3. Apply to sale was dated 31/08/2222. Receivables recon is balanced only if I date it 31/08/2222; Statement of Account reflects the correct balance of the client as of current date. Hope you can help me on this. Thank you.1KViews0likes7CommentsReceivables Reconciliation [Summary] - out of balance
Hi, I generated the Receivables Reconciliation [Summary] and it shows an out of balance against the Trial balance amount of Trade Debtors account. I was able to identify what specific transaction caused the error, and it is an irreversible transaction (order converted to invoice). Hope you can help me on how to proceed on this. Thank you.