Reconciling Calendar to Fiscal

Modified on Thu, 03 Aug 2017 at 10:57 AM

Some of the Design Manager Reports look at the Calendar Date of the Transaction, while other reports look at the Fiscal Month of the Transaction. The Sales Tax Report and the Checkbook/Credit Card Registers all look at the Calendar Date of the Transaction. The Financial Reports, such as the Trial Balance, the Balance Sheet and the Income Statements look at the Fiscal Month. What this means is that you may run into a situation where one report doesn’t match another report. In the example below, we are going to look for a $120.00 discrepancy between the Balance Sheet and the Checkbook register at the end of December of 2016 and this company has a fiscal year end of December.

The first thing we want to do is run the Transaction Search (Go to G/L then select Transaction Search). Enter in the Checking Account G/L number (or whatever account is displaying the difference) and look for everything that is posted to fiscal 2016 (or before) but has a calendar date in the future (as shown in the picture below) then click the Find button. In this example, our search came back blank, which indicates that there are no transactions in the Checking account that are dated in the future.

Another search needs to be run to search for any transactions that are dated in December, but posted into the “fiscal future”.

That search yielded a result. From the search we have a check that is dated 12/31/16 but posted to fiscal 03/17. This means that the Checkbook Register will show a reduction in December of 2016, but the Balance Sheet will not show the reduction in cash until March of 2017.