In 2008, FarmBooks will receive the following enhancements:

VIEW AS PDF

Enforce FICA Limits

Incorporate into the Payroll Module the maximum limit for the withholding of Social Security tax.

This change has been implemented during paycheck entry and all payroll reports updated to utilize the FICA limit defined in the tax table for any year. Paycheck entry shows all YTD amounts prior to the current check being entered or edited.

Form 941 - Employer’s Quarterly Federal Tax Return

Payroll Form 941 (Employer’s Quarterly Federal Tax Return) was redesigned for the 2005 calendar year, and future calendar years. Additional lines have been added and other changes incorporated.

Form 940 – Employer’s Annual Federal Unemployment (FUTA)Tax Return

Payroll Form 940 was redesigned for the 2006 calendar year, and future calendar years. Additional lines have been added and other changes incorporated.

Form 943 - Employer’s Annual Federal Tax Return for Agricultural Employees

Change the 12.4% and 2.9% values on Lines 3 and 5 to the decimal format of .124 and .029.

Form 944 - Employer’s Annual Federal Tax Return

A new IRS form developed in 2006 for depositing of FICA taxes and income taxes withheld on employees. Form 944 is used by employers instead of Form 941 if the employer is notified in writing by the IRS. Tax deposit is done annually instead of monthly, quarterly, etc.

Paycheck "Other" Withholding Values

After a paycheck has been completed but not recorded, pressing the Enter (or Tab) key through the address line will cause the program to automatically reopen the Paycheck Detail Window. If the user had entered a value in the "Other" withholding box, then this value would have moved to the "Retirement" box when the Paycheck Detail Window was reopened. (NOTE: The Paycheck values will be correct because the values for Retirement/Other are combined on one detail line with the ATIG code of "9414".)

This has been accomplished by back figuring the percentages from the employee window when showing the detail window. If the employee has no values defined, the split values will not be maintained. The final solution will be incorporated with additional payroll changes in the next release.

Payroll Analysis – Single Employee Report

On the report setup screen, the user enters the Employee’s Number. When the number is entered, the Employee’s Name should be displayed.

Paycheck Detail Grid Changed

The grid was changed to remove columns that were not relevant to payroll. Hours and Gross Pay columns were added.

Crop Enterprise Analysis Report

Beginning with the Net Sale Grain line, the "$/Unit" values should be derived by dividing "Dollars" by "# Unit Produced.” Currently, the dollar values are divided by "Pounds/100".

Inventory Analysis Report by Type of Livestock

Do not print this report for a type of livestock if no inventory, purchase, sale, death, weaning, and birth entries have been entered for that type of livestock. That is, the report is blank.

Non-Farm and Nonfarm Issue

Standardize all reports and screens on use of either "Non-Farm" or "Nonfarm", but not the use of both. It was decided to use Non-Farm and the following changes were made:

• Change ATI = 007: "Nonfarm Utilities" to "Non-Farm Utilities"
• Change ATI = 008: "Nonfarm Auto Expense" to "Non-Farm Auto Expense"
• Change “Nonfarm” in the Balance Sheet & Support Schedules and Detail Inventory Listing Reports to "Non-Farm".

Other than the above, the term "Non-Farm” is used throughout the program.

Balance Sheet Report Dates

Allow the user to enter a specific date to be printed in the heading of the ending Balance Sheet and Supporting Schedules Reports. This "date" is especially important for the ending Balance Sheet. For example, an ending inventory may have been entered on the data of August 15th to obtain a Balance Sheet report as of that date.

Balance Sheet Supporting Schedules Revisions

In the Supporting Schedules, include the "Qty Code Terms" such as Bushels, Acres, Head, with the units. Also, change the term "value" to "Amount".

Report Dates and Page #’s

Move the page #’s as well as the date and time a report was printed to the bottom of the report.

Balance Sheet Supporting Schedules and Detail Inventory Listing Reports

Change the following terms:

• Supporting Schedules: Section 16:
  - Change "Account Payable" to "Accounts Payable"
• Detail Inventory Listing:
  - Change "Account Payable" to "Accounts Payable"

Vendor Recall Last Transaction

Provide a method of recalling the last check or deposit detail for a vendor. This feature is only available during new check / deposit entry.

"+ / - " Sign Quick Key for Check Number

Pressing the plus or minus key within the check number field will increment or decrement the check number by one if the field contains a number.

Vendor Quick-Fill Mixed Upper-Lower Case Issue

If typing in a name that is not set up as a vendor but starts with a few of the first letters of a vendor that is set up in upper and lower case letters, it starts to do the quick-fill of the vendor, but the rest of the name that is then typed is in all capitals. For example, if a vendor is set up as "John Deere" and the user is entering a check for Johnson County, then it will pick up the "John" part of John Deere but the rest of the name is in all capitals. Thus, the name will be listed on the check as "JohnSON COUNTY".

Retain Check Amount on Payee Change

The check / deposit amount will be retained if the payee is changed. It was always reset to zero in prior versions.

Bank Balance Summary Report of Check Register Reports and the Separate Bank Balance Summary Report

The print screen allows for the entering any range of dates, but the report does not cross fiscal years.

Example: The report for transaction dates of 7/01/2006 – 12/31/07 will be identical to the report with transaction dates of 01/01/2007 – 12/31/07. Since you can not cross the fiscal year dates, then the "YTD Balance" does not make sense and is not needed.

Example: A Bank Balance Summary report for the dates of 01/01/2006 to 12/31/2006 will show a balance as of 12/31/2007. If the report was processed on 2/9/2007, then the YTD Balance as of 2/9/2007 will print. But, the balance will be identical to the 12/31/2007 balance. That is, the YTD value printed is not the balance for this checking account as of 2/9/2007. Also, the **End of Report** term can be removed.

New and Changed ATIG Codes

See the Code Changes List
Analyzing an existing farm database will apply the new and changed code descriptions. Any new farm created will have the new and changed codes without doing the data analysis.

Access Violation When Changing Fiscal Year from Register Tab

Changing the fiscal year on the register tab could result in an access violation being reported. The application would continue after closing the message box. This has been fixed.

Reconciliation New Features and Fixes

Counts added for "cleared" and "un-cleared" checks and deposits.

Changing the sort view could result in un-reconciled transactions from other bank accounts to be included with the current bank account.

Fixes to Register Tab Grid

The new grid with additional features was introduced in Version 3.0, sometimes the grid did not show the data or would show additional fiscal years.

When setting up a new farm database and entering checks during the same session, the checks would not be displayed in the grid. It would require you to close the farm and then reopen it.

Entering new checks and then returning to the register tab grid would not always display the new checks.

Having the view set to "Show Detail" as unchecked would result in all fiscal years data to be display on application startup. It would appear to user that it was showing the wrong fiscal year when comparing the data being displayed to the fiscal year in the drop down list.

New Fiscal Year – Loan / Receivable Roll-Over Balance

When creating a new fiscal year the loan / receivable beginning balance for the new fiscal year was not always correct. This was especially true if the same external code was used on all loan payments or receivables.

Top

VIEW AS PDF

Registration Changes

The application had three different places where the registration information could be changed (File menu - Change Registration, Setup menu - Personal Information, and Utilities menu - Maintain Registrations). Each one had a strength or weakness from the other ones. This set of changes will bring consistency between them and did eliminate the option from the Setup menu - Personal Information.

History of the various methods:

• Method 1 (File menu - Change Registration):
  This option would only allow you to change the farm registration number. You were not permitted to change the farm number and / or name.
  
  
• Method 2 (Setup menu - Personal Information):
  This option would change the registration number and / or name and update the farm number in the transaction file; however, the folder name would not reflect the current registration information. To update the folder, it would require you to go to maintain registrations and delete the registration number and open window explorer and rename the farm folder, then go back into maintain registration and ADD the registration. Again, the main benefit was that it updated the farm number that was stored in the transaction files.
  
  
• Method 3 (Utilities menu - Maintain Registrations):
  Maintain Registrations would allow you to ADD a registration with a new number and / or name, but the farm database folder is not renamed to reflect either the number and / or name change. The transaction files have the farm number stored in them to be checked against the registered farm number when opening the database. However, this process would NOT update the farm number in the transaction files and so it would result in an error when opening the database - "Transaction files do NOT belong to registered farm."
  
  This method still has one advantage over the two methods. If you create a new fiscal year and you have NOT entered any transactions, it will allow you to remove the fiscal year along with ALL the setup data. However, if the farm has loans and or receivables defined for the farm (New Fiscal Year process creates beginning balance), it will require you to manually delete these beginning balances before you can remove the fiscal year. This would allow someone to delete the fiscal period should it get created with the wrong start date. It does require you to have at least one fiscal year before you are permitted to remove one. Without a fiscal year, you don’t have a registration record. This functionality is not available from the File menu - Change Registration.

Solution:
Since it was desirable to rename the farm folder if either the farm number and / or name changed, the second method (Setup menu - Personal Information) had to be removed since it is not possible to rename a folder while the database is actually open. The other two options were changed to allow you to change the farm number, name, and or registration number. The process will now rename the folder, update the transaction file with the new farm number, and update the registration information.

Maintain registrations shows a database legend as to what the various colors indicate for the database icon. Also, a new status was added to show registered farms that no longer have a valid number (version 3.0 required new numbers). A new properties level was included to shows the farm number, registration number, and database folder. This should help in determining what folder is being used by what registration.

As a side note, "Open Farm" and "Change Registration" will now show three different database icon colors, yellow - active usable database, blue - registered but no data folder, and gray - registered but not valid) the same as maintain registrations (no legend provided here as the user will receive an error message).

Check Printing Changes / Register Grid Refresh

Added printer dialog prompt to allow the user to change the printer before the printing of checks; Windows default print is still the default but now the user can override if they have more than one printer;

If the checks did not print correctly, the user can specify the first check that printed incorrectly. However, the next check number was incorrectly set to the next check number. Also added some additional description on the check confirmation window to better explain the use of the voided check range.

After printing one or more checks that were marked "PRINT" and designating the appropriate starting check number during the process and clicking "OK" to say the checks printed fine, the word "PRINT" shows in the Register instead of the appropriate check number. If more checks are printed later, then the previous set of checks then reflect the check number but the current set of printed checks will still show "PRINT" as the check number. Closing the bank account or the program and opening again seems to "pop" the check numbers in. The register is now refreshed properly.

If you would change the bank account when entering a check, paycheck, or deposit and then return the register grid, the grid would show the correct bank account name, but the data shown in the grid was not properly refreshed to match the bank account. This has been corrected.

Check Number Change

In this version, we no longer left fill the check numbers with leading zeros. No change was made to your existing data.

If you use the "Next" or "Next and Cleared" (used if you don’t print checks from FarmBooks) preference options for "Check Number and Status", then you should set your beginning number for each bank account you have defined from the Balances menu and Bank.

Report Changes

• ATIG Codes Listing was not sorting by G Code. If you added a new code that did not exist, the code would always appear at the end of ATI group.
• Detail Register List and the Check Register Reports had the rightmost column moved as it was being cut off. Also, updated the drill down report for the same reason.
• Income Statement - The report has been updated to show the G Description from the ATIG instead of the transaction user description.
• Inventory Detail Listing show 5182 "Bermuda" with the "a" on the next line by itself.
• Monthly Cash Flow - Report has been updated to read its data from the transaction file instead of the summary file.
• Schedule F had a misspelling. Is correct on the statement but not on the worksheet. Under the caution statement at the bottom of the page it is listed as "Feader Steers", but should be "Feeder Steers".

Version number updated to 3.01 for all changed reports.

New Report Control Features

Batch Printing Options - Added a "mark all" and "clear all" buttons to allow user to quickly select and deselect ALL reports without drilling into the various report levels.

General Report Preview Options - Added default Magnification Percentage. This value can be set from the "Report menu - Reports and then select the "Options" button.

Inventory Grid Entry

Entry into the quantity code field required you to use the mouse to select the value from the list. Now, the user can enter the quantity code without using a mouse or the drop-down list. The novice user can still browse the list of codes if necessary.

The grid is designed for quick entry of information from left to right using the enter key to move between columns.

Automatic Default Preference Change Notification

The backup option for the local device was set to "C:\MCFP Backups". During the installation to FarmBooks, the user is instructed to change this to "C:\FarmBooks Backups". Now, when the user opens the preferences, it will detect the prior setting and automatically adjust it to the FarmBooks default. During this process, the user is notified of the change.

If you set the backup folder to any location other than C:\FarmBooks Backups, it will automatically save a copy to this folder on the local computer as a secondary backup.

New Fiscal Year and Export Process - Loans / Receivables with no Beginning Balance

Summary of Problems for Roll-over and Export.

• Loan always created as Current Liability
• Receivables always created as Stockholders A/R
• Grouping by External Number limited External Code to only one Liability and / or Asset Type

The roll-over options would not create the correct liability and / or asset type if there was no beginning loan and / or receivable balance defined. Also, if there was no beginning balance for the loan and / or receivable, it could have possibly been created using the bank account name instead of the external code. For instance, a loan with external code 003 would get the bank account description for 0023 instead of the loan/receivable code. Loan 004 received the correct description in the case where there was no bank account defined for 0024. Both of these problems have been corrected in the case where no beginning balance was defined.

In prior versions, the loan/receivable roll-over grouped by external number only and limited the external code to one liability or asset type. Now, the process has been updated to group by both the external code and the ATIG. This allows both a current, intermediate, and / or long term (liability or asset) to be created for the same loan external code. The roll-over in general was incomplete for new fiscal year. This has been corrected.

Minor Application Changes for Error Messages, Images, Register Grid Advanced Filter, and Quick Key

• Updated open error message to include the farm number and name to be more clear which farm open was in error
• Updated and added new images within the application - Inventory, Livestock Production, Maintain Registration, and View Log. Most of them now have more of a 3-D look
• Added Callout Control with Application Icon to show Fly-Over Text Messages
• Cleaned up the names of filter field name list for the advance filter popup window. Also, removed some that did not make sense in this setting. For instance, the grid is restricted by bank account and fiscal year so these would not be of additional value in filtering. This would be for the advanced user or could be used by support.
• Detail Register Grid – Pressing the enter key will automatically apply the filter. In prior versions, it was necessary to select the filter button and then select apply. However, if you want to enter several criteria values and then apply the filter all at once you can tab between fields and then select the filter button and then select apply or press the enter key on the last criteria field.

Top