Hello, Have you tried adding a filter criteria on the measure item and choose as option “is not null”? It helped in my sheet, hope it will for you too Thanks Tanya Row 2 has a repeater on Account, with a filter to an account that we ended use of in 2022, as well as IS NOT NULL. Column C has a repeater by Year. 2022 was the only year we used that account for IFS purposes. I guess I’m trying to find a way to exclude zero balance accounts, regardless of whether activity occurred or not. Also played with the “Treat Null as Zero” toggle in the Report Options tab in the ribbon and have not seen what that does other than putting zero’s in the non-activity balances.
Hello @DV - JL, Did you find a solution to not show zero value cells on business reporter? Thank you Tanya I have not yet, but I potentially honed in on an issue. When I have the row design repeating on account, and filter to one specific account, if both current and previous years are $0.00, the line will not appear. If I have the row design repeating on account, and there’s multiple accounts it CAN display, it will still show the $0.00 balance accounts. Not sure if this helps with the issue, helps with something for you, maybe not helpful at all! :) Long story short no, but still hopeful.
As an alternative you might use external files. Simply said: you can copy one or multiple files (from a repository where you store the files for your recurring vouchers) to the import folder (using a cron job or other tool) for external files and upload and post it automatically. I am not aware of a time scheduled / automatic function for that. We are essentially using the external files like you suggest, and I just have a calendar reminder on my PC to do it every month. Still fast, but not “automated”. Thanks Ralph!
Hi, As noted, the period allocation is a great tool that allocates an amount (insurance invoice) over multiple periods. For other common recurring type postings - month end entries (payroll and other) accruals that are nor spread over the months, we use the Voucher Template. A voucher template can optionally save amounts for example same amount every month, or for payroll where the value is different every month you would not include the amounts. Best regards, Can voucher templates be scheduled, as to make them “automatic”? I don’t see the option (cloud based version) but we are quite new to IFS.
Hello, I don’t have the answer to provide although I would like to ask for an advice : In your process, how did you get the “final matching” option ? which amounts should be equal and which should be set to zero on the “automatic matching” screen to be able to run the final matching ? I am trying it and I would like to know on which amounts should i focus in order to get this button Thank you :) Tanya From what I have seen, you get the “Final Matching” Button once all of your Bank Transactions (bottom section) are cleared. I believe what the IFS programmers were getting at is that every item on your bank statement should be taken care of before you are “finalized”.I have a situation where there ARE some bank transactions that won’t clear until the next month. At that point, I can go back to the previous months’ bank reconciliation and be able to see the “Final Matching” button at that point. Hope that helps.
I’m afraid that for this we usually use one of the reporting tools available instead. Typical option would be to use Business Reporter for this. I’m actually looking for the exact opposite. I’m using the Business Reporter and do not want accounts with a zero balance either in the current year or previous year to show up. Any suggestions there? Thanks!
Hi @Emila75, Please find the below steps for bank reconciliation (manual transaction matching). Open the ‘Manual Transaction Matching’ window. Select the account from the list for which you want to match transactions. Enter the ‘Reconciliation Date’ (Take the statement date as reconciliation date) and ‘Bank’ Balance (Closing balance on the statement) Look at the bank statement and select the ‘Match Transaction’ check box for each cash book transaction that matches a bank statement transaction and save the records. When all matching cash book transactions have been marked check the total amount of the ‘Unmatched cash transactions. This should be equal to the difference between the cash book balance and the bank balance (i.e., amount displayed in the ‘Difference’ field) once the bank reconciliation process is completed for the reconciliation date. Hope these steps help you to perform the Bank reconciliation. I suggest you perform bank reconciliation for the previous years also. If
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
