Sage 100 month end close

Sage 100 Month End Close

How to perform Sage 100 Month End Close Procedure and Checklist

for Sage 100 ERP Small Business Accounting

Month End Close Tips and Tricks

Closing Steps

In Sage 100 the most 5 basic steps include entering all deposits and checks, bank reconciliation, reviewing of financial balances, printing and saving reports and finally closing each module and then beginning entry of  transactions into the new accounting period.

Module Information

Every individual module in Sage 100 has its own steps that should be performed prior to the close. All transactions must be updated to the module and to the general ledger.  By following an organized list each month you will keep your system in balance and moving forward.


Small Businesses walk thru these steps each month end to make sure financial reports are accurate. The result of completing each month in a timely manner is so that the owners can determine profitability each month during the year. The bank reconciliation which is included as a part of the month end close steps confirms all transactions for the monthly period were recorded and is a critical part of the process.

Tips and tricks

Sage 100

Five accounts to reviewed and reconciled each monthly:

  • Cash
  • Accounts Receivable
  • Inventory
  • Accounts Payable
  • Gross Wages

If you are a larger company there may be additional accounts that need to be reviewed for accuracy each month such as fixed assets, prepaid expenses, loan accounts and tax liabilities. If you are distribution or manufacturing company it may include WIP, Finished goods and cost of goods sold. For a month end close checklist follow the links below to request a month end close checklist in excel for your small business.

Sage 100 Small Business Month-End Close Checklist

Request Month End-Close Excel Checklist

Sage 100 Small Business Quarter End Close Checklist

View Quarter End Checklist

Sage 100 Small Business Year End Close Checklist

Review Year End Close Checklist

For more information and support on Small Business Accounting Software visit Accounting Business Solutions by JCS and for services on Sage Software Timeslips visit

Sage 100 Barcode

Sage 100 Barcode Software

How to understand solutions for barcode for Sage 100

Sage 100 barcode

Sage 100 Barcode

Automate your business and reduce errors with Sage 100 Barcode Scanning

Sage 100 ERP barcode for warehouse automation is designed to improve inventory accuracy and warehouse efficiency, allowing your businesses to focus on your operations. Learn More

Streamline your Sage 100 picking and packing process

Work smarter not harder with more reliable information you can speed up your inventory and warehouse processes with the Sage 100 Barcode module with mobile scanner integration.

Real time inventory information

With reliable, real-time Sage 100 inventory data, you can make quicker more informed business decisions.

What is a Sage 100 Barcode?

Typically printed on a label to identify a Sage 100 inventory item. A barcode is a method of representing part numbers / SKU data in a visual, machine-readable form. Barcodes represent characters of data by varying the widths and spacings of parallel lines. These barcodes, now commonly referred to as linear or one-dimensional, can be scanned by special optical scanners, called barcode readers.

What are barcode readers?

A barcode reader (or barcode scanner) is an optical scanner that can read printed barcodes, decode the data contained in the barcode. These can be directly attached to a hardware device, a rugged handheld scanning device and today smart phones.

What are UPC codes?

UPC codes are also knows as bar codes, but are issued by a central authority for a fee, and are thus unique in all the world.  If you’re not selling through a retail chain, you don’t need them.

Why is a Sage 100 barcode different from a Sage 100 Point of Sale software?

This is where you get into the POS software:  UPC codes must be ‘mapped’ to an internal or external stock number.  The UPC code may be similar, completely different, or nonexistent, for any given SKU.

There’s no mapping system built into Sage 100.  There’s an internal item ID, a 52-character part code, and a description.  The part code is search-able, but only from the beginning of the code.  The description is searchable on any character.  There a 5, 100 character ‘user’ fields in which you can put any data you like, but you can’t access any of that data from any invoice data entry screen.

Some Sage 100 inventory item numbers may be set up with the UPC, like “123456789 Scooby Doo Lunch Box”, or may have descriptions that contain the UPC, like “Scooby Doo Lunch Box 123456789”.   Once that’s all set up, you can program your bar code reader for the appropriate number of [TAB] entries to get it to the right place on screen.

Sage 100 Scanners

If you use a directly attached scanner you can plug it in to your hardware and scan a few bar codes in the item maintenance window, while adding lines to a sales order or purchase order. Most Barcode “Wedge” scanners do not have to be configured.  They have computer chip in them that decodes just about any barcode they come across.  Some are programmable, so that when you pull the trigger and they pick up a valid bar code, they will send (for example) [enter] [tab] <the ascii text in the barcode> [tab] [tab] to the program being used.

There are many different formats of bar code.  One of the easiest ways to print barcodes, is to use a “3 of 9” font in Windows.  (sometimes called Code 39).  There’s no checksum to calculate and print, all you need to do is put an asterisk (*) character at the beginning and end of the text that you want to encode.  (Obviously, you can’t use the asterisk as part of any barcodes). Requires an asterisk at the beginning and end of the ASCII text.   It’s start / stop codes are easy to add (i.e. in Excel)

Most barcodes have a start / stop code, and / or a Checksum.  The start / stop code is how the bar code reader knows it just saw the whole barcode.  The Checksum is how the reader knows it saw it correctly. Code 39 uses only a start / stop code.   Code 128 uses both.

What is Sage 100 Barcode Code 39?

Code 39 is a variable length, discrete barcode symbology. Code 39 uses characters that are displayed in this example it’s “=Concatenate(“*”,A1,”*”).  The Code 39 specification defines 43 characters, consisting of uppercase letters, numeric digits and a number of special characters. An additional character is used for both start and stop delimiters.

Code 39 is a bit more prone to misreads, since there is no checksum.  (but still less prone to error than manually entering these item ID’s. If you are looking at using Code 39 AND picking up UPC-A codes then the part number will need to be the UPC number unless your scanner can interpret both.

More about Code 39 can be found:

What is Sage 100 Barcode Code 128?

Code 128 is a high-density linear barcode symbology defined in ISO/IEC 15417:2007. It is used for alphanumeric or numeric-only barcodes. It can encode all 128 characters of ASCII and, by use of an extension symbol, the Latin-1 characters defined in ISO/IEC 8859-1.

Code 128 Requires a ‘Check Digit’ calculation included in the barcode. Also uses encoded start / stop codes that aren’t the same as each other. It is possible to have a scanner use UPC-A codes as long as the inventory item numbers are the UPC-A numbers unless your scanner can interpret both.

More about Code 128 can be found: .

Where do I get more information on fully integrated Sage 100 Barcode Scanner?

Sage 100 now offers mobile barcode scanning with Sage Mobility for Barcode. Fewer errors, process more transactions easier and run leaner operations. Sage 100 scanners use pre-existing barcodes or it can generate new ones for you. Plus, it’s completely integrated with Sage 100 and automatically fills fields with the correct information when barcodes are scanned.

Sage 100 Barcode scanning integrates seamlessly with Enhanced Pick, Pack, and Ship and true physical inventory counts or cycle counts. For more information about Sage 100 Scanners for Sage 100 visit Or give us a call 800.475.1047. Put our 30 years of Sage 100 experience to work for you. Sage Timeslips Support

Sage 100Cloud Software News 2019

Sage 100Cloud Software News 2019

Save while you can. The latest software offer on Sage 100Cloud until 9/30/2019.

Outgrown your current Accounting Software?

Sage 100cloud is ideal for companies that have outgrown their current accounting software or manual processes. This powerful business management solution can collect, store, manage and interpret data across one business or multiple businesses. Over the past several years Sage Software has added so many rich benefits. With so much in functionality now your company can combine modules to build an ERP system optimized for your business as it grows.

For Small to medium sized manufacturing companies

Move beyond simple accounting software with Sage 100cloud manufacturing to help you manage your manufacturing. They new Manufacturing and Production Management modules have all the power most small to medium sized manufacturing companies need.

If you are a make to order, custom manufacturer, repetitive manufacturer, assembler, or job shop this manufacturing program is worth a look. If you perform field service once the product has been installed at your customer there is a module that can handle this also. Visit Sage 50 Support.

For existing MAS 90, MAS 200 and Sage 100 users

If you are out of date on your maintenance program and now would be a good time to upgrade.

If you’re using a retired version of Sage 100, you’re no longer eligible for product updates and therefore not taking advantage of latest features and upgrades! This is a very cost effective way to get back on a current maintenance plan.

If any customization’s have been made to your Sage product there are a few special considerations that need to be reviewed prior to upgrading to the latest version such as are those previous enhancements now built into Sage 100Cloud manufacturing.

To learn more give us a call 800.475.1048


Sage 100Cloud

Sage 100Cloud


Timeslip Training

Accounting Software Training

Microsoft Power BI Affordable and Powerful

Microsoft Power BI Affordable and Powerful

Microsoft Power BI affordable and powerful. Do you need better reports from QuickBooks, Sage 50Cloud or Sage 100Cloud? Are you looking for interactive dashboards so you can quickly measure performances in your business?

Microsoft Power BI is an affordable, streamlined business analytics, intelligence, and reporting solution. With Microsoft Power BI, you can use the valuable data your business generates to improve your operations. Unlock the value of your data. Microsoft Power BI is a platform that lets everyone in your business make informed decisions from anywhere and on any device. This tool can be used with accounting systems such as QuickBooks, Sage 50Cloud and Sage 100Cloud.

Microsoft Power BI gives you big business analytics without the big cost. Consolidate data from various sources, then query the application to find meaningful information that can help you drive business decisions in real time. Connect with other applications you already use, and easily share information with your team.

Microsoft Power BI is a business intelligence (BI) tool that allows users to crunch data and create BI reports through a self-service interface. Use powerful drag-and-drop tools to create meaningful reports from and perform critical analysis on your data in new shape.

As of 7/16/2018 Microsoft Power BI has three pricing plans: Power BI Desktop: This offering is free to any single user and includes data cleaning and preparation, custom visualizations and the ability to publish to the Power BI service. Power BI Pro: The Pro plan costs $9.99/user/month. Current pricing is subject at the decision of Microsoft taken from

In the Power BI service, users have defined capabilities based on two types of licenses:

  • Per-userPower BI Pro licensing and free licensing. A Power BI Pro license enables access to all content and capabilities in the Power BI service, including the ability to share content and collaborate with other Pro users. Only Pro users can publish to and consume content from app workspace, share dashboards, and subscribe to dashboards and reports. A free license enables access to some of the features of the Power BI service. For more information, see Per-user license type comparison.
  • Capacity-basedPower BI Premium licensing. Premium provides dedicated capacity to deliver more consistent performance and support larger data volumes in Power BI. For individual users, Premium also enables widespread distribution of content by Pro users without requiring Pro licenses for recipients who view the content. For more information, see What is Power BI Premium? Visit Sage 50 Support.


This tool can be used with accounting systems such as QuickBooks, Sage 50Cloud and Sage 100Cloud. For additional information give us a call 800.475.1047 or email

Per-user license type comparison – Here is a list of features supported by per-user license type.

Microsoft Power Feature Comparisions Sage 100 Sage 50 QuickBooks Sage Intelligence


Sage 100Cloud Dashboard New Data Visualization

Sage 100Cloud Dashboard

New Data Visualization

Are you looking for new ways to slice, dice and visualize data and to share your discoveries for your Sage 100Cloud with your business team? Discover Sage 100Cloud Dashboard because Microsoft Power BI is a powerful tool and we can help you get where you want to. This new collection of tools and features from Microsoft transforms your company’s data into rich visuals for you to collect and organize, so you can spot trends, collaborate in new ways, and make sense of your data by using Sage Intelligence with Microsoft Power BI.

All business need comprehensive data analytics solutions to gain insights into business operations and financial performance. It is an importance for your business to be able to review this data and have an analysis process with analytics charts and reports including this data giving knowledge and measurable KPI’s. These are the primary data tables you need to understand in Sage 100 Accounting Software and we can help you discover them or design and create the dashboards for you.

  • Master lists
  • Data entry
  • History
  • Work tables

Accounting Business Solutions by JCS’s Microsoft Power BI Consulting Services our team wants to be part of your team so we can grow together and we are a perfect match to help you with your data visualization needs using Sage 100cloud dashboard. We can help you quickly view your complicated and piles of data and get the information you need to make business decisions. Once created these types of dashboards can present data very quickly and provide you a complete view of your information in an easily understandable format using an interactive data visualization tool. Specializing in Sage 100, Sage Intelligence and Microsoft Power BI services.

Sage 100Cloud Dashboard – Providing Sage 100Cloud support, Sage Intelligence consulting services and Mircosoft Power BI design and implementation. Give us a call 800.475.1047 or email at


Sage 100 Sage Intelligence Microsoft Power bi support consultant training

sage 100, sage 100 support, sage 100 era, sage 100cloud, sage 100c, sage 100 manufacturing, sage 100 consultant, sage100, sage 100 classes, sage 100 training

Sage 100 2018.3: Job Costing Module Changes

With each annual Sage 100 software release, Sage introduces periodic updates for their Sage 100 2018 software, which include useful improvements and bug fixes to help your Sage 100 product run more efficiently. The most recent update, Sage 100 2018.3, includes many helpful changes to the Job Costing module.


What’s new in the Sage 100 2018 Job Costing Module?

  • Fix “(Tax Code)” is not numeric” in version 2018 Job Billing Data Entry for a Fixed Contract job
  • No longer receive “record (report Name) is missing from SY_ReportManagerMaster.M4T.” when using the Designer button to open any report on the Job Cost > Estimating menu.
  • Cost Code Maintenance is no longer truncating alphanumeric Cost Code numbers that include a special character.
  • Job Estimate Printing *SUB and *TOT calculation is now correct if the line is deleted and re-entered to a different line on the grid.
  • New Comments or changes to Comment are now retained in Job Maintenance.
  • Corrected issue with Time & Material transactions not summarizing by Job in Daily Transaction Purge Closed Jobs Dated on or Before
  • Users are now able to enter an Actual Percent Complete greater than 9% in Job Billing Data Entry.
  • User can able to proceed the Sales Tax Calculation with J/C Job Billing selected. There is no Error 88 AR_Salestaxcalculation_bus.pvc 119 displayed.
  • Fix Error: “A missing GL account was found in Job Type: xxx” in Job Billing after converting to version 2018 and “Post to G/L for Work in Process” is unchecked in Job Cost Options.
  • A/R Invoice with a job referenced is no longer adding $1 Sales Tax Billed to the invoice in Job Billing History – Version 2018.
  •  Calculated Overhead Allocation amounts from Job Posting Entry transactions are correct.
  • Error 26 is not occurring for the Job Transaction Detail History Report & Job Transaction Detail Report when selecting Save As for the reports.
  •  Job Billing Data Entry Fixed Bill Totals tab is now displays the Job-To-Date Cost instead of the Year-To-Date Cost.
  • Transaction Date is retained in Primary Grid when exiting Job Posting Entry.
  • Trans Date in Job Posting Entry is now defaults to Module Date not System Date.
  • Cost Code Detail Unit Price and Unit Cost amount can be entered after the decimal.
  • Job Billing Data Entry line Bill Amount is recalculate correctly when Bill Rate is changed for a Time & Material job in version 2018.
  • Fix Job Billing Register update to G/L does not relieve WIP when Post to G/L for WIP is selected in Job Cost Options.
  • Added validation in Cost Types to not allow special characters. Increased size of Valid Cost Type field to 36 characters.
  • PO Receipt Register and PO Return Register update hangs when there are multiple lines which include Job Cost detail.


sage 100 2018.3 job costing moduleAccounting Business Solutions by JCS is a leading Sage 100 consultant offering Sage 100 support, training, and data repair services to help fix the problems you may be having with the Job Costing Module in Sage 100 2018.  Our certified Sage 100 consultants have years of experience helping businesses just like yours maximize the efficiency of their Sage 100 ERP software. To get started with Sage 100 software, call us at 800-475-1047 or email us at Your success is our goal!

The Sage 100 2018.3 download link can be found here.

Manufacturing Inventory Accounting

Manufacturing Inventory Accounting: What Happens to an Inventory Account When Materials Are Bought, Requisitioned, Manufactured, used in jobs or Sold?

If your company is a construction, distributor or manufacturing business using software and are seeking information to help understand how it should work within the software system or if you are new to these processes and are looking for better inventory control, this will help.

This document is intended to give you a high-level view and help you understand what happens to quantities on hand when items are bought, requisitioned, manufactured and/or sold. Each part of the process has its own best practices and its’ own ‘accounting under the hood’ during these various phases of inventory control. Let’s get started. Here is a simple rundown to help you understand these concepts from beginning to end.


Individual items are often referred to as raw material or components in a manufacturing environment; products for distribution; or materials for a Job. They are typically purchased through the use of a purchase order and received at the dock. The quantity on hand is increased by the number of items received and the cost of each item is typically tracked by some predetermined costing method. Tracking allow us to see the quantity and value of our inventory as an asset. Later, that tracking will also provide the tools to assign costs when they are used in manufacturing or are used on a job. Ultimately, that tracking allow us to assign a cost when completing a sale, thus granting the ability to view the profit that has been realized. Along the way, we can keep up to date with information about quantities bought, sold, used, expended, transferred or lost to mishap. Some business requires traceability for the movement of items throughout the entire manufacturing process or from purchase to sale. Manufacturers often refer to this as “quote to cash.” The receipt of items at our dock, should increase the value of our inventory while at the same time establishing either a liability for the purchase or an accrual, pending receipt of a future accounts payable invoice.

Purchased items may also be delivered directly to a client location. Usually when the documentation for this type of delivery is recorded, it is considered a ‘drop shipment’, and we are concerned mainly with recording the increase in our material expenses. When the delivery client location is a job address however, we may rather increase an asset amount in a work in process account.

Items may also be managed as non-stock when we are either, not concerned with tracking it’s value, don’t need to worry about quantities on hand, stock availability, profitability per item or sale or where tractability and/or more exacting profitability figures are not required. Sometimes it makes sense to use nonstock items when the cost of the item is so small that managing the process of recording the information is not cost effective.

When making the purchase where a vendor ships product to you and allows you to pay on account, the accounting that occurs is an increase (or debit) to inventory with a corresponding increase (or credit) to a liability account. If an invoice is received with the materials or goods, the liability would be recorded as an accounts payable amount, but if not, it is accrued in a pending payables, purchases clearing account or Accounts payable accrual account depending on your companies terminology to be relieved or transferred to accounts payable when the invoice document actually arrives and is recorded.

When making a purchase where cash, check, debit or credit card is used to directly buy inventory, the offset to an increase (debit) in inventory value would either decrease (credit) our cash in the bank or increase (credit) in the liability to our credit card company. If you are using a credit card to make the purchases, you may also want to reconcile the credit card accounts when the statement from the vendor arrives.

When recording the completed shipment of items that were ‘drop shipped’ to our clients, we usually increase (debit) our expense for the goods we purchased unless the materials were delivered to the site of our ongoing job, the transaction would most likely increase (debit) a work in process (WIP) account. Both of these would be offset appropriately based on the terms of cash or credit purchase provided by the supplier and as already outlined above.

Material Requisition, Issues, Usage or Assembly:

The first step of production, when manufacturing, is the purchase of the items or materials needed. These materials may be purchased to stock for later use during the manufacturing process or directly to a job for a project. Material issue, is the movement of materials from stock into the production process, typically for a specific job, project or production run. The entire production process is recorded in the financial records of the company, and each stage of the process may have its own journal entries. This doesn’t always mean that the overall value of inventory actually changes. Learning about the journal entries that take place during the course of the production process can help you understand the effects of production on your overall financial position. A work in process (WIP) account, may be used to track the value of materials that have been specifically earmarked for a job to help segregate them from items that are available directly for sale, while still tracking costing and other information to allow for reporting on budgeting, management of resources, traceability and ultimately to allow for profitability reporting and budgets versus actual expenses and revenue.

Issuing materials, also known as putting materials into production, is the second step in the production process. Normally, company’s account for direct and indirect materials separately. Direct materials, meaning materials that can be directly traced to finished products, are recorded as an increase (debit) in work in process and a decrease (credit) in inventory account associated with that material at the time they are issued to a production run or job. When recording indirect materials, those that cannot be directly traced to finished products, we instead increase (debit) a manufacturing overhead account while decreasing our materials inventory. Because the process of issuing direct materials is a transfer between two inventory accounts, the overall inventory balance on the financial statements may not change during the lifecycle of any given production step.

Manufacturing of Finished Goods is closely related to job costing, but there are a few major differences.

Manufacturing typically utilizes the demands on inventory to assist in the timing of the inventory procurement process. To manage manufacturing production, we may need shop floor controls and the ability to track the status of items as the process of production plays out. Steps in the manufacturing process may need to be tracked to derive required item status information or when coupled with workstations, provide a framework to assist with capacity planning. Jobs tend to be broken into steps called phases and cost codes, but here the statuses we need to track are usually a % of completion. Specific instructions or CAD drawings needed for a production step may sometimes be more detailed than phase plans found in job costing. Both manufacturing and job costing may benefit from the ability to establish estimated revenue, estimated expenses and to track and manage change orders. Bar code capabilities may also provide a great assistance in a manufacturing environment by helping to manage item movement during the receiving, issuing, usage or consumption to the job and shipping steps.

When items are used during the manufacturing process, most often the material used in production are depleted by one of three methods.

Bill of Materials Assembly/Production:

This is a good choice if production management does not require work in process tracking and either the items you make have a consistent bill of materials or are repetitively manufactured items with only minor alterations to the materials needed. At the point where production is recorded, meaning the finished item is completely assembled and ready for shipment to the customer, the quantity of component items, defined by the bill of materials, are removed from inventory and finished items are increased by the quantity produced. The cost associated with the finished quantity is a factor of the cost of materials used. At the most basic level, the cost of the materials used is simply moved from the raw materials inventory account to the finished goods account. In more comprehensive systems, additional costs, like labor or overhead, may also be included in the cost associated with the finished product. These additions may be added as additional costs to increase the finished product inventory account, but would come out of an overhead or a labor used in manufacturing account, rather than a raw materials inventory account.

Work Orders or Work Tickets:

This method is most effective if you have manufacturing process where there is a significant need to manage inventory demand over time. In other words, if production takes a long time to complete and items need to be accounted for as they are used, or if your need to correlate multiple distinct production runs in order to properly manage material demand, work tickets provide an excellent tool. Work order systems often also proved tools to allow for variation on a standard bill of materials.

Work order systems may include the ability to predefine the steps needed in the manufacturing process and allow for the printing of ‘shop travelers’ or other documents to help manage the process through all of its stages. At some point, in this type of system, the cost of materials are moved from their raw materials inventory to a work in process tracking account. Once goods are completed, the costs are transferred out of the work in process account, decreasing (crediting) it’s balance. At the same time the total cost of production is used to increase (debit) the finished goods inventory. With complex bills of manufacturing involving multiple steps, the work in process account may have been increased as each step is completed and other costs like overhead or labor are recorded. Like a material issue, final assembly is often recorded as a transfer between inventory sub-accounts, and the overall inventory balance does not change. For more complex production, inventory accounts may have increased as the additional costs associated whit each completed step are recorded. The cost of goods manufactured will remain in the finished goods inventory account until the goods are sold.


The last method is often called kitting. In this method when a finished product is invoiced, special behind the scene tools in the system, decrease the materials inventory by the quantities defined for the kit, based on their cost as tracked by the inventory system. In this instance there is a decrease (credit) in the materials inventory account with a corresponding increase (debit) in our cost of goods sold account with no intervening involvement of a finished goods inventory account.

Additional Cost of Manufacturing

Costs, other than materials, may be included as part of any of the depletion methods to increase the cost of a finished product in stock or increase the costs associated with a project or job when it is sold. These additional costs may include, labor, labor burden, subcontracted work, overhead or equipment use. Often these costs have been accounted for in other ways, so the GL accounts affected usually decrease (credit) an expense account in order to correspondingly increase (debit) the inventory account associated with the finished product. Many manufacturing systems, when the process is being tracked on Work Orders or Work Tickets, allow the definition of the operations that take place and work stations where operation steps are performed to produce a finished product. As reporting takes place on the status of these operational steps, these systems often record the the accumulation of these additional cost while allowing for oversite and management. Defining work stations and operations also provide a framework for the scheduling or available resources allowing management to identify conflicts for those resources and providing a timetable to completion. When bills of material (BOM) are combined with the management of operations and shop floor resources, it is often referred to as a bill of manufacturing. In a simple BOM assembly or kitting situation, these additional costs are often standardized and added in to the bill of materials.

Sales and Cost of Goods Sold

Deposits to jobs or manufactured items normally should be reflected as a deposit to the job, project or order. Deposits generally increase (debit) our cash in the bank while at the same time, increase (credit) our liability in a customer deposits account of some sort. The deposit should be applied to the balance due from the customer usually during the final part of the billing cycle. In a manufacturing situation, this is usually when the item is shipped while in a job cost situation where billings may be periodic or incremental, it could take place at any time up until long after the final billing when the job or project is finally considered fully complete. When the deposit is finally applied, the amount decreases (debits) customer deposits while at the same time, decreases (credits) accounts receivable, reducing the balance due from the customer.

The final step in a manufacturing environment is the sale of the items produced. The quantity being sold is shipped and recorded as such on an invoice to deplete the quantity on hand for each item being shipped. The revenue is recognized as an increase (credit) to the appropriate sales account while also increasing (debiting) accounts receivable and the balance due from the customer. Since inventory is being depleted, the inventory account is also decreased (credited) by the cost of the item and that same cost, will increase (debit) the cost of goods sold (COGS) account associated with that item. The cost associated with the sale is dictated by a costing method assigned to the product being sold.

The difference between revenues and cost of goods sold is the gross profit on the sale. If the increase (credit) to our sales account is more than the increase (debit) to our cost of goods sold account, the sale resulted in a profit.


Job Costing needs tend to differ from manufacturing in the following areas:

Both Manufacturing systems and Job Cost may require that labor, labor burden, overhead, sub-contracted services or labor, and equipment costs be rolled into the cost of what is being sold. Both often want to be able to estimate or budget their work and duplicate or review prior work for to achieve more competitive sales while insuring a profit. Each has a hierarchy of applied cost. Though highly individualized for every business entity, Manufacturing tends to rank materials as their most important cost, followed by an overhead consisting of labor, equipment, labor burden and transportation while sometimes including subcontracted services. In Job Costing time (both supplied and subcontracted labor and equipment) followed by materials is the usual hierarchy followed by labor burden and other overhead costs.

They both may also want to break their work into smaller steps for better reporting and management with the added benefit of incremental reporting providing the potential for forecast possible issues in time to make changes prior to the completion of the work. For Manufacturing, those increments are often broken down into work centers or operations, while in Job Costing we see breakdowns called phases and cost codes.

In Manufacturing systems, we generally bill customers for the product that was manufactured while Job Costing might follow one of 3 main billing methods; percent of completion, completed jobs and time and material.

The term Job Costing is most often used in the construction industry. Often the project lifecycle is longer than in Manufacturing. Labor and outside service along with actual material tend to be posted to a job during the period in which the expense occurred and comparison reporting between the actual expense and budget are review on a regular basis. Some job costing applications also use a WIP (completed job) type accounting method. Most Job Costing applications are geared towards cost tracking and often do not assist a business in the procurement process or scheduling process.

In the completed jobs accounting method, actual costs are accumulated in to WIP accounts during the life cycle of the job. Once the job is completed and the final invoice to the customer is created, the accounting entry increases (debits) accounts receivable while increasing (crediting) revenues. At the same time the expenses that have been accumulated in WIP are removed (credited) from WIP and added (debited) to the appropriate expense accounts. Both these transactions are normally recorded in the same accounting period.

In percentage of completion jobs, billing is based on the percentage of actual work has been completed for a Job. This could be based on a comparison of estimated vs actual expenses as tracked in the system or on a percent complete as reported from the jobsite. For example, if $500 of an estimated $2,500 in expense costs have been spent or if the project manager has reported and had approved completion of 20% of the work, the 20% of the total sale amount can be billed for the billing cycle. This billing method may use a WIP type accounting method, where cost are accumulated in WIP and redistributed at the time of billing as in the completed jobs method, or the costs may simply be expensed as they occur. When expensed directly, each invoicegenerated for a job, will only increase (debit) accounts receivable while increasing (credit) revenues.

In Time and Materials (T&M) Jobs,  all costs are directly expensed to the job. From the tracked time costs, like labor, subcontracted services or equipment usage, and tracked material costs, are used to bill the customer. Revenue is recognized when each customer invoice is generated and expenses are recorded at they are received.


Accounting Business Solutions by JCS specializes in inventory control software, assisting contractors, distributors and manufacturing companies in leveraging technology. Our consultants are certified in Quickbooks and Sage software, including Sage 50 and Sage 100, as well as manufacturing add-ons such as JobOps and MiSys Manufacturing. Call us today at 800-475-1047 today!

Sage Software Sage 100 Month End Checklist, Sage 50 month end checklist, Sage 100 support, Sage 50 support

Sage 50 / Sage 100 Month-End Checklist for Sage Software

Sage 50 month end Checklist or Sage 100 month end checklist

One of the main benefits of using an accounting or an ERP system is the organizational advantages offered by these products. Whether you are using Sage 100 ERP or Sage 50 software, it is crucial to keep your monthly finances accurate and up-to-date. Never fall behind with our handy Sage 50 / Sage 100 Month-End Checklist!

Sage 50 / Sage 100 Month-End starter Checklist: Get the full version of  month end checklist here

  • Enter your sales and purchase invoices for the month.
  • Enter all monthly payments and receipts from check stubs and paying-in slips.
  • Enter direct debits, ACH transfers, checks, and so on from your monthly bank statements.
  • Reconcile bank accounts for the month, including credit cards.
  • Enter journals or run wizards for accruals, prepayments, depreciation and so on.
  • Depending on where you live and your payment schedule, calculate, file, and pay your monthly state and federal employment and sales taxes.
  • Run Aged Debtors and Aged Creditors reports for the period.
  • Run Profit and Loss and Balance Sheet for the period.
  • Run month-end wizard (Tools→Period-End→Month-End).


Sage 100 Month End Checklist, Sage 100, Sage 50, Sage 50 Month End Checklist, Sage 100 support, Sage 50 support, sage software

Sage Software certified consultant

If you need help learning how to use these helpful Sage 50 / Sage 100 month-end features, call the certified Sage consultants at Accounting Business Solutions by JCS today! Our experienced, professional staff offers a full range of Sage software consulting services, including Sage 100 support, Sage 100 classes, Sage 100 data repair, Sage 50 support, Sage 50 classes, and Sage 50 data repair for all years and versions of your particular Sage product. Our nine locations, which include Detroit, MI, Chicago, IL, Charleston, SC, St. Louis, MO, Mandeville, LA, Dallas, TX, Naples, FL, Atlanta, GA, and Sacramento, CA, are conveniently located throughout the United States to serve you better. We also offer remote assistance and in-house help. Get help with your Sage 100 or Sage 50 software by calling 800-475-1047 today, by emailing us at, or by filling out our contact form. Your success is our goal! get your month end checklist here

JCS announces Nomination 2nd Year in a Row! – 800.475.1047 – Training – Support – Consultant – Reseller

JCS announces Nomination 2nd Year in a Row! – 800.475.1047 – Training – Support – Consultant – Reseller

We are excited to announce Accounting Business Solutions by JCS has been nominated again this year for 2018 Enterprising Women of the Year Award.

Last year, we announced receiving 2017 Enterprising Women of the Year Champion Award.

“Our success is dependent on great relationships. Our customers and our staff are the 2 best assets we have as a business. Hence, our motto ~ Your Success is our Goal” says Jennifer O’Brien, Lead Project Manager.

This year we are once again nominated for receiving this prestigious recognitions among women business owners across the country. We couldn’t be more humbled about this nomination.

Accounting Business Solutions by JCS provides customer service and support using Sage 50 Accounting, QuickBooks and Sage 100 as the base accounting systems. These systems can accommodate all size businesses effectively by offering valuable solutions for automation and detailed intelligence reporting thus creating streamlined efficiencies for businesses.  Reports are at your fingertips to manage finances, inventory, sales, purchasing, employees, payroll, and CRM databases.

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”          800.475.1047

Like us on Facebook  and follow us on Twitter

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

What’s New in Sage 100 and Sage 100c 2018

What’s New in Sage 100 and Sage 100c 2018?

Support – Training – Consultant – Reseller

Feature enhancements for the latest updates in Sage

Sage 100 2017.2

Accounts Receivable – Payment Setup Wizard

To help set up credit card and ACH payment processing through Sage Exchange account a payment setup wizard has been added. After setting up your Sage Exchange account, the wizard will guide you through enabling ACH payment processing and credit card processing in Company Maintenance and creating payment types.

Payroll – Sage 100 Direct Deposit Service Processing

Changes were made to the Process Employee Pre-Note and Direct Deposit Transaction Window:

  1. A warning message will appear if you select a batch that has already been sent or has an effective date that has passed
  2. The Select Sent button has been renamed to Select Batches Previously Transmitted and is now at the bottom of the column of button
  3. The Select Not Sent button has been renamed to Select Batches Never Transmitted and has moved to the top of the column of buttons

Sage 100 2017

Global Enhancements

Enhanced Auto-Complete

In previous versions this feature only considered the beginning of the text in the searched fields. Now, when using the updated feature, your search criteria is compared with all words within the searched fields. For example, if you have a customer named Allen’s Appliance Repair and a customer named Appliance Services, typing Appl in the Customer No field results in a list that includes both customers. The number of fields included in the search has been expanded to include the ability to search for vendors by phone number. Try typing the phone number (digits only) in the vendor no. field.


Build Search Index Utility

In order to activate the enhanced auto-complete feature, run the Build Search Index utility on the Library Master Utilities menu. If this step isn’t run, the auto-complete will run as it did prior to the enhancement. This utility can be run after creating a new customer, vendor and item records so that the records are indexed and appear in the auto-complete results. When running the utility it updates the index for all of your companies. Use the Task Scheduler to automatically run the indexing utility on a regular basis.

Full Text Search Option in Lookup Windows

A full text option has been added to the Search list in the Lookup windows. When Full Text is selected, search criteria is compared with the data in all columns available in the lookup window. The search criteria must match the beginning of a word. For example, if you have a customer named Market Supplies and another customer named Village Market, if you type Mark in the search results, Village Market will not show up.

Search for Empty Fields in Lookup Windows

Now there is the ability to search for fields that do not contain any value in the lookup windows. Select a field from the Search list then select Is Empty from the operand list then click find.

Maintain Commodity Codes for Miscellaneous and Inventory Items

Maintain a list of commodity codes and associate them with miscellaneous items. Commodity codes are included with the data send when processing level 3 credit card transactions in the Sales Order module.

  • A Commodity Code field has been added to the Main tab in Product Line Maintenance. A Commodity Code check box has been added to the Apply Product Line Information window so that you can apply the code entered in the Product Line Maintenance to the selected Inventory items within the product line.
  • There is a new Commodity Desc field displays the commodity code description in Sales Order Entry and Sales Order Invoice Data Entry.
  • Common Information Setup menu now has Commodity Code Maintenance added. This task can be used to maintain a list of commodity codes and their descriptions. Codes and descriptions are available in the lookup views for Commodity Code fields. Click the Apply button to assign a Commodity Code range of items.
  • Selecting an item in the Sales Order Entry and Sales Order Invoice Data Entry, the code entered in the item’s maintenance task is the default value in the Commodity Code field. This can be changed.
  • The Commodity Code Import Wizard which is available on the Common Information Utilities menu will guide you through importing commodity codes from tab-delimited text files.
  • On the Main tab in Miscellaneous Item Maintenance there has been a Commodity Code fields added. You can create a new code on the fly or enter an existing code.

Larger Font for Selected Reports

Font size used for selected reports has been increased to improve visibility. Reports have previously been viewed in 6 point font but now is 30-40% taller.

Prior and Next Buttons for Calendar Window

Use the Prior and Next buttons to quickly change from month to month on the calendar window.

Cancel Button Available when Printing Reports

Cancel report printing by clicking Cancel button on the message window that appears while the report is processing.

Suppress “Remove Forms” Message

There is now an option in Role Maintenance that allows you to suppress the message that reminds you to replace forms with paper after printing.

Resizable Memo Maintenance Window

Resize the Memo Maintenance window by dragging the lower-right corner of the window.

New Options on Help Ribbon

New buttons on the Help Ribbon include:

  • Create a Support Ticket
  • Access Sage 100 Knowledgebase
  • Start a chat session with Sage 100 Tech Support

Accounts Receivable

You can now enter ACH payments in the following tasks:

  • Repetitive Invoice Entry
  • Cash Receipts Entry
  • Accounts Receivable Data Entry

This feature is enabled when you have Sage Payment Solutions account that is set up for ACH payments. Enable the feature on the Payments tab in the Company Maintenance and set up ACH payment types in Payment Type Maintenance. Some fields, tasks and tabs have been renamed to reference ‘payments’ instead of ‘credit cards’. Details in the following sections.

ACH Payment Processing

ACH payments are submitted to the Sage Payments Solutions as part of the Cash Receipts Journal and Accounts Receivable Sales Journal update process. They cannot be processed individually.

Data Entry Tasks

The following changes were made in the data entry tasks

  • ACH Payment related fields have been added to the Cash Receipts Deposit window and the Cash Receipts Entry Header tab.
  • The Credit Card tab has been renamed to the Payment tab. Fields related to ACH payments have been added. The Payment ID field has replaced the Credit Card ID field.
  • The Fix button is now available on the Payment tab based on the Allow to Override ACH Payment Transaction security event in Role Maintenance.

Reports and Listings

  • Print a customers’ ACH payment information has been added to the Customer Listing task window. The last 4 digits of the bank account appear in the listing.
  • Credit Card Settlement Report has been renamed to Credit Card and ACH Settlement report to include ACH payments on the report.
  • The last 4 digits of the bank account appear for ACH payments on the Deposit Transaction Report

Maintenance Tasks

  • Now you are able to select ACH Payment as the payment method when in the Payment Type Maintenance
  • An ACH account field now displays in Invoice History Inquiry which displays the last 4 digits of the ACH payment bank account for invoices with ACH Payments. The Payment Information button has replaced the Credit Card Information button and will open a new Payment Information window to view additional details about the payment.
  • ACH payments now appear in the secondary grid on the Customer Maintenance Invoices and Transactions tabs.
  • On the Customer Maintenance Additional tab, the Payment ID field has replaced the Card ID field
  • Customer Credit Card Maintenance window has been renamed Customer Credit Card and ACH Payment Maintenance

Changing Transaction Information

Allow to Override ACH Payment Transactions has been added for security. This security event enables the Fix button on the Payments tab in A/R Invoice Data Entry and Cash Receipts Entry which allows users to update payment transaction information.

Bank Reconciliation

Following check boxes have been added to the Bank Reconciliation Report task window:

  • Keep Window Open After Preview
  • Keep Window Open After Print

Improved Export to Excel or Financial Reports

The Excel file is easier to view and manipulate when exporting Bank Reconciliation reports. Minimum font size 8 points and empty columns and rows are minimized.

Customer Relation Management

Now included with Sage 100 is Sage CRM 7.3. To obtain information on what’s new in this version, see Sage CRM 7.3 SP3 Release Notes. This document is available in the Documentation link in the Sage CRM installation program. On the Auto run screen that appears, click the Documentation link when you start the Sage CRM installation.

Library Master

After selecting a role in Role Maintenance, you can click the Search button and enter search criteria. Matching security events, tasks and module options appear and you can select one to go to its location on the applicable tab.

Sales Order

Enter ACH payments in Sales Order Entry and S/O Invoice Data

A Sage Payment Solutions account is set up you can enable this feature.


For more information on Sage 100, Sage 100c give one of our professional consultants a call 800.475.1047

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”          800.475.1047

Like us on Facebook  and follow us on Twitter

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming


TAGS: Sage 100, Sage 100c, Sage 100 Support, Sage 100c Support, Sage 100 Consultant, Sage 100c Consultant, Sage 100 Reseller, Sage 100c Reseller, Sage Features, Sage 100 Features, Sage 100 Enhancements, Sage 2017, Sage Training, Sage Consultant