Bank reconciliation ensures the cash balance reported in a company’s accounting records matches the balance shown on the bank statement. Issue: Subledger doesn’t balance to G/L bank account One of the most important things when performing bank reconciliations in Business Central is ensuring your bank account subledger balances to your GL bank account. The bank… Continue reading Microsoft Business Central: Common Issues and Resolutions with Bank Reconciliation
Category: General Ledger
Account Schedules Renamed to Financial Reporting in Business Central
This video examines the name change of Account Schedules to Financial Reporting in Microsoft Dynamics 365 Business Central and other changes now found in the Financial Reporting area. The change happened in the major update to Business Central in October 2022. Besides naming and navigation changes, functional updates are discussed in this video. Topics include… Continue reading Account Schedules Renamed to Financial Reporting in Business Central
How to Use the G/L Account Balance to Budget Feature in Business Central
In this how-to video, the topic is the G/L Account Balance to Budget feature in Microsoft Dynamics 365 Business Central and how this functionality offers users the ability to view historical financial data when creating new budgets. Budgets play an important role with business intelligence, such as financial statements based on account schedules that include… Continue reading How to Use the G/L Account Balance to Budget Feature in Business Central
How to Add Deferred Revenue and Expenses in Business Central
Alex Wiley, a PreSales Consultant at ArcherPoint, provides a quick, five-minute video tutorial on how to recognize revenue or an expense in Microsoft Dynamics 365 Business Central. In Business Central, a user can recognize a revenue or an expense outside the period that the actual transaction is posted, which can be helpful when automatically deferring… Continue reading How to Add Deferred Revenue and Expenses in Business Central
How To Import Account Schedules in Microsoft Dynamics Business Central or NAV
This blog explains how to import account schedules into a database in Microsoft Dynamics 365 Business Central or Dynamics NAV. Important steps include: Export Customer Data Export Default Cronus data Export Default Cronus Package Import Cronus package into Customer database Import Cronus data Let’s get started with a backup. Normally, you do a backup of… Continue reading How To Import Account Schedules in Microsoft Dynamics Business Central or NAV
How to Use Data from Microsoft Dynamics 365 Business Central In Excel Using OData Feeds
Connecting to Excel with OData fields can be very powerful, not only for Power BI, but also for Microsoft Dynamics 365 Business Central. By simply connecting to a Business Central page as an OData feed, you can pull data into Excel to create pivot tables and more, opening the door to many benefits. In this… Continue reading How to Use Data from Microsoft Dynamics 365 Business Central In Excel Using OData Feeds
How to Create a Journal Entry in Excel and Upload it to Dynamics 365 Business Central
A client recently asked me for instructions on how to create journal entries in Excel and then be able to “Copy and Paste” or “Upload” the entry from Excel to Business Central (If I had a dollar for every time I’ve heard “QuickBooks can do it…”). I had been addressing this before by showing a… Continue reading How to Create a Journal Entry in Excel and Upload it to Dynamics 365 Business Central
Dynamics NAV 2017 Account Subcategories
Dynamics NAV 2017 and Account Subcategories I recently have explored some of the new features that Dynamics NAV 2017 has available, and the Account Subcategories deserves a closer look. In a prior blog I mentioned how the Account Category in Dynamics NAV 2017 can be used to set the Income/Balance Field. In this blog, we… Continue reading Dynamics NAV 2017 Account Subcategories
Dynamics NAV 2017 Account Category
Dynamics NAV 2017 and Account Category I recently had the opportunity to explore some of the new features that Dynamics NAV 2017 has available. One of them looks very interesting, so I thought that I would share it with you. In the G/L Chart of Accounts a few new fields have been added. These fields… Continue reading Dynamics NAV 2017 Account Category
Using NAV Item Journal to Issue Items to Different Expense Accounts
Scenario: You would like to Debit different General Ledger Expense Accounts when you issue stockroom material using the Dynamics NAV Item Journal. For instance, if the engineering department uses stock room inventory for a project, you would like to debit the Engineering Expense Account for the cost of the inventory. Without doing any additional setups,… Continue reading Using NAV Item Journal to Issue Items to Different Expense Accounts