You may have go to run a Income Statement in Business Central or a Balance Sheet and have found the report returns nothing. That is because you have to build it! Business Central offers much greater financial reporting and analysis than other accounting systems, however that does mean there is some setup. Or what I […]
Continue Reading
If you have not come across this blog before or have not read the about me bio I am a qualified accountant who now consultants in finance/business systems in particular Microsoft Business Central. So why are we talking about Xero? I work with many systems not just business central and have many years of experience […]
Continue Reading
You have mastered creating drop downlists in excel (If you have do not worry we will link out blog post on how to do this at the bottom of this post) But now you want to select multiple options from that list. You may have already looked into this and seen it involved VBA code […]
Continue Reading
Converting the data in a PDF into excel is a common task we face and it can be so annoying when the format does not come across properly. Or if you manually entering the data into Excel this is far too time consuming. A Boardroom Mum is bringing you a hack that will save time […]
Continue Reading
You maybe wondering how to post a bank receipt in business central, it is using the cash receipt journal. What is a cash receipt journal? This journal is used to process any income, it is not only used for bank receipts it can be used to post income to any account in business central. For […]
Continue Reading
Using filters in business central can seem overwhelming at first and to be honest its a not as easy as other finance systems such as Sage. However once you get to understand them and how to use them they offer so much better analysis – you will forget any other system. The last A Boardroom […]
Continue Reading
Filtering and “dynamic” dates and filters in business central are a very powerful tool. However so many people who have used business central for years have no idea how to use these. A boardroom Mum is bringing you a series of articles to level up your filtering skills in business central that will not only […]
Continue ReadingDrop down lists are really useful and lets me honest look really cool! Find out how to create them in Excel here; There are two ways to do this; First option; Open a Google sheet; Hit @Dropdown and they will enter Then using the Data Validation Rules on the left hand side enter your options. […]
Continue Reading
Business Central has the capability to manage Cash accounting VAT. What is cash accounting VAT? Where VAT is declared and reclaimed on payment of invoices and credits rather than the invoice date. Unrealised VAT is how business central manages VAT cash accounting. How to set up Unrealised VAT or VAT cash accounting in business central. […]
Continue Reading
Want to create drop down lists in Excel like this; Lets walk through it step by step in the above example; In our example that will be =INDIRECT(“Invited”) Now you will be able to use the drop down menu to choose any name from that table into the cell range you have chosen. Please browse […]
Continue Reading