Sage 50 Cash Flow

How to create a cash flow statement in Sage 50

Sage 50 cash flow

What does a cash flow projection consists of.  This report may be required if you are looking at additional financing for your business or need to report to a board of directors or potential buyer.  It is also useful for anticipating future cash shortfalls.  After reviewing what makes up a cash flow projection, we will go through an example using data from Sage 50.

 

What is a Sage 50 cash flow projection?

A cash flow projection consists of three main parts:

  • The beginning cash balances
  • Plus, anticipated cash receipts
  • Less Expected cash disbursements

Sage 50 Cash Screen Shots Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

 

 

 

 

 

In Sage 50 there is a built-in Sage 50 cash flow statement.

It is found under analysis – under the main task bar and then by selecting cash flow.

 

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

You have the ability to select the cash accounts you want to include in the cash flow projection. Once you select them there will be a visible check mark in the include box to the left of the cash account ID.

 

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

Displayed will be the account number, description and the cash balance as of today if you are running in real time or have smart posting activated. As you can see, we have four bank accounts with a total available balance of $57,238.60 but will only be working with the regular checking account with a balance of $16,116.52 as of today.

The next step is to specify the time frame to be included in the projection found in the upper left corner of the window.

 

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

We will now work with the file tab expected incoming cash. Most businesses will use the current outstanding customer invoices as the source of the expected cash receipts section. This information is from the Sage 50 customer open invoice file.  For this example, we will assume that we receive the cash on the due date for the full amount of the invoice.

 

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

By default, most of these invoices will be select to be included in the projected cash balance. However, as you can see there are a few invoices with a date displayed in red. This indicates they are past the due date of expected payment. To include them as an exception, edit the date field and modify it to have an expected date after today’s date. And then use the include column to add it to the calculation.

 

If the business has another source of cash that is not showing up in the current receivables this should also be included.  Examples of these could be rents, royalties, or any kind of investment income and perhaps customer deposits.

 

To add a what if for other types of expected incoming cash you will use the adjustment in the type field,

Enter a value in the code number, id and name, date and amount fields and be sure to use the include column to add it to the calculation. In this example we have added an expected deposit on a project from a client of $15,000.

 

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

Next, we will work with the file tab expected outgoing cash. Expected cash disbursements for most businesses come from two sources:

  1. The outstanding vendor invoices
  2. Payroll and related expenses such as taxes and benefits

 

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

This information is pulled from the Sage 50 vendor open invoice file.  Like the customer invoices these are assumed to be paid on the due date in the full amount and are spread out over the same periods.

 

If you need to add a what if for other types of outgoing cash you can also add it to this file tab as an adjustment in the type field, Enter a value in the code number, id and name, date and amount fields and be sure to use the include column to add it to the calculation.

 

As we mentioned with cash receipts, if there are any additional cash requirements not listed above, they should also be included. Examples of these may be loan or line of credit payments, recurring and automatic payments from your bank accounts.

 

Under the bar – change cash flow settings

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

You have the option for open transactions or historical transactions and in the lower portion of the window you can specify the types of transactions you want to use for incoming and outgoing cash transactions.

 

For Sage 50 Cash Flow – modify the time frame you wish to work with

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

You can calculate this based on the average days to pay or transaction due date. Once you are finished with your decisions use the update cash flow bar to refresh your balances.

 

Exporting Sage 50 cash flow to Excel

– use the excel icon on the upper task bar. Once this is started You will now see options for your export.

 

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

You can create a new excel sheet or choose to add to an existing sheet.

 

You can choose to use freeze panes and define how the header will be displayed.

 

Once this is complete an excel worksheet will automatically be created with the following tabs.

You can view, save and print these. Let’s look at the starting cash file tab which lists each account along with the beginning cash balance for each account.

 

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

Under the file tab Expected Incoming Cash is a list of balances by customer by invoice of 87,197.51

 

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

Under the file tab Expected outgoing cash is a list of balances by vendor by invoice of 28,374.68

 

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

To review the summary file tab

 

The starting cash balance is $16,116.52 as of today.

There is a total of +87,197.51 expected incoming cash included

With a total of –28,374.68 expected outgoing cash included

With a projected cash balance of =74,939.35

 

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

This format of this report can be easily modified using your excel skills and then shared with others.

 

Discounts are one additional consideration which may affect the amount of the receipt or disbursement to be expected.  The invoice balances already recorded would generally be used for planning but if you offer early payment discounts to your customers or if your vendors offer them to you, these should be considered if they are normally taken or given.

 

Lastly the timing of the receipt or disbursement need to be addressed.  Every invoice should have a due date associated with it.  However, as mentioned previously, early payment discounts may provide enough incentive for someone to pay earlier than that date.  In addition, although an invoice may have a net 30 days terms associated with it, it is not uncommon for the average time an invoice is paid to stretch a little.  Most systems will keep track of the average days to pay by customer and vendor.  This number, added to the invoice date, can provide a more realistic model if utilized.

 

If this is a format you wish to return to you can save your selections and the what if scenarios that have been identified for later use.

 

Accounting Business Solutions by JCS provides sales, setup, implementation, training and data migrations for Sage 50. And Consulting and Technical Support after the sale. Sage 50 support, sage 50 training, sage 50 consultant, sage 50 training classes, sage 50 training class, sage 50 class, sage 50 classes, Sage 50 help, sage 50 data migration, sage 50 software, sage 50 data repair, sage 50 accounting, Sage 50 custom reports, sage 50 software, Sage 50C support, sage 50C training, sage 50C consultant, sage 50C training classes, sage 50C training class, sage 50C class, sage 50C classes, Sage 50C help, sage 50C data migration, sage 50C software, sage 50C data repair, sage 50C accounting, Sage 50c custom reports, sage 50c software, Sage 50cloud support, sage 50cloud training, sage 50cloud consultant, sage 50cloud training classes, sage 50cloud training class, sage 50cloud class, sage 50cloud classes, Sage 50cloud help, sage 50cloud data migration, sage 50cloud software, sage 50cloud data repair, sage 50cloud accounting, Sage 50cloud custom reports, sage 50cloud software,

 

Thank you for joining us to learn more about creating a cash flow statement in Sage 50. Accounting Business Solutions by JCS provides sales, installation, integration and training services for Sage 50 Accounting Software as well as technical support and custom reports. 800.475.1047. If there is anything we can do to help give us a call.

pros and cons of Sage 50, sage 50 Accounting, cost of Sage 50 accounting software, sage software, sage 50cloud reviews

Sage 50 Month End Close

How to perform a Sage 50 Month End Close

Steps to complete a Month End Close Procedures and Tips and Tricks

for Sage 50 Small Business Accounting

Month End Close Tips and Tricks

What is a month end close in Sage 50? The 6 basic steps include

  • Entering deposits
  • Recording checks
  • Complete Bank Reconciliation
  • Review financial balances
  • Print reports
  • Change to the new accounting period

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 one of the most  critical part of the process.

 

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. Often this is the basic for future financial decisions. View Sage 50 system Requirements.

Sage 50 Tips and tricks

For Sage 50 users on any version

  • Sage 50 Quantum
  • Sage 50 Premium
  • Sage 50 Pro

5 accounts that need to be reviewed and reconciled monthly are:

  • 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 50

Sage 50 Bill of Material assembly sub-assembly work ticket build

Sage 50 Bill of Material

Sage 50 Bill of Material

I wanted to provide you with the process below which I think will help clarify how Sage 50 assemblies work. Hopefully this will be enough information to test thru the process with me or your team. The reason for my suggesting you walk thru this is to see the effort required to manage multiple level bill of materials.

When using multiple level bill of materials Sage 50 does not have the capacity to help you manage processes like scheduling, timing of demands for inventory items or shop floor routing and scanning capabilities. I bring these points up to confirm whether or not you might need those now or in the future to help your day to day operations become more efficient.

Sage 50 Bill of Material by Sage Software

Sage 50 can do multiple level bill of materials. Most often the challenge is that each sub assembly needs to be completed One at a time Before the final assembly can be completed and invoiced. Sage 50 does not have a back flush feature to allow

You to have clients request a delivery date and then manage the purchase order or build process to calculate the needed start date.

That said Sage 100 will step up to those needs. I can get a demo set up for this application so you can see the difference. The only conflict I am aware of in running Sage 50 and Sage 100 on the same serve is a potential conflict in the versions Of crystal reporting.

Discovery

Once we have a discovery call on Sage 100, I can then pull together pricing. If you wish I can get this on our schedule and we can offer estimates of conversion. We have migrated many clients in similar positions.

Yes, you can have some folks on Sage 50 and Some on Sage 100. A Consideration would be consolidated financials If you are doing that now using Sage 50 consolidated financials. That said Sage Intelligence may be able to provide this with a bit of setup. During the initial discussion we can him his opinion of Sage Intacct which may be Another option.

Let me know how you want to proceed. I am here to help. 800.475.1047

This is the process To set up inventory items

Set up all raw materials as inventory item class “stock”

Example of stock item is PTWheel-6

Set up all sub-assemblies as inventory item class “assembly”

Example of sub-assembly is PTHANDLE-ASM

Set up finished item – as inventory item class ‘assembly”

the components could be raw materials and/or sub-assemblies

Example of finished item is Red Lawn Mower

Item ID Item Description Qty Needed Qty on Hand Est Cost
Red Lawn Mower Red 18″ Reel Mower w/Tracking
. PTHANDLE-ASM 4′ Handle Assembly 1.00
. . PTHANDLE-BENT4 Handle – 4 ft bent 2.00 150.00 13.18
. . PTBOLT-1.5 Hex bolt 1.5″ 4.00 1,280.00 1.32
. . PTNUT- 5/16 Hex nut 5/16″ 8.00 1,180.00 0.56
. . PTBOLT-2 Hex bolt 2″ 4.00 900.00 1.36
. PTWHEEL-6 6″ Wheel 2.00 70.00 12.00
. PTWHEEL-10 10″ Wheel 2.00 70.00 16.00
. PTBLADE-99-9 16″ 5 blade 1.00
. . PTBLADE-16-5 16″ 5 blade 1.00 56.00
. . PTNUT- 5/16 Hex nut 5/16″ 6.00 1,180.00 0.42
. PTBOLT-1.5 Hex bolt 1.5″ 6.00 1,280.00 1.98
. PTNUT- 5/16 Hex nut 5/16″ 6.00 1,180.00 0.42
Red Lawn Mower Total  Cost 103.24

In this example the highlighted items in orange are the sub-assemblies – this is the report found at

Reports – inventory – bill of materials

In the items that are sub-assemblies or final assemblies there is an option on the bill of materials file tab

Which allows you to include or exclude the component items from the customer orders.

Sage 50 Bill of Material – the process to build your finished items

You can build using one of two available methods

  • Option a. Assembly Build
    • Found under tasks – Assemblies
  • Option b. Work Tickets
    • Found under tasks Work Tickets

Either of these you would need to

Step 1. Build the sub-assemblies one at a time using assemblies or work tickets

Step 2. Build the final product

This build of the final product is the step that rolls up all costs

The thing I like about work tickets is you have a printable document

Where you can add some steps to help identify the process and give direction

Then when the build is complete a document that can be provided to the front

Office to complete paperwork and invoicing

Then when you ship/invoice the final product you would have

  • Reports by customer
  • By item
  • Sales
  • Cost of Sales
  • Profitability

The only item needed on the sales order or invoice is the finished item

+ any misc. items you may wish to include

I would recommend

As in any product you not allow the inventory to have quantities on hand

Go into a negative level.

I am here to help give us a call 800.475.1047

Sage 50 Bill of Material assembly sub-assembly work ticket build

Sage 50 training and Sage 100 training for Sage Software available from Accounting Business Solutions by JCS

778 West Algonquin Road

Arlington Heights – Chicago, Illinois

Specialist in Sage Software

Accounting Business Solutions, Accounting Business Solutions by JCS, JCS Computer Resource, JCS, JCS software, sage 100, quickbooks, sage 50, MISys, Sage 100 manufacturing

Sage 50 2019

Sage 50 2019 – Is it time to make the decision to use the most versatile small business accounting software?

What are the System Requirements for Sage 50 2019

  • Processor operating frequency:
    • Pro and Premium Edition: 1.0 GHz or higher (2.0 GHz recommended)
    • Quantum and Accountant Edition: 2.0 GHz or higher (Multiple-core processor operating at 2.33 GHz recommended)
  • 4 GB RAM. Recommended 6 GB RAM
  • 4 GB hard disk space (additional 1 GB needed for installation)
  • Latest version of Internet Explorer
  • Microsoft® supported version of Windows 7, Windows 8.1 or Windows 10 (with the latest updates from Microsoft)
  • 256-colour or higher SVGA monitor, minimum resolution of 1024 x 768
  • CD-ROM drive
  • Forms that can be sent via email require MAPI-compliant email client, Internet connection, and email service
  • Sage 50cloud integration to Microsoft Office 365 requires Microsoft Office 365 Business Premium
  • Multiuser (Premium and higher) optimized for Windows 7, Windows 8.1 and Windows 10. Dedicated server recommended: Windows Server 2016, Windows Server 2012, Windows Server 2012 R2, Windows Server 2008 R2, Windows Small Business Server 2008 R2
  • Terminal Services: Windows Server 2016, Windows Server 2012, Windows Server 2012 R2, Windows Server 2008 R
  • High speed Internet connection (for subscribed Sage online services, for example, Sage Drive)

Integration with other software packages

  • Word and Excel integration requires 32-bit versions of Microsoft Word and Microsoft Excel 2010, 2013 or 2016

Conversion: Converts all data from previous versions of Sage 50 starting with Sage 50 Accounting Release 2014.0. And yes it is possible to convert to a lower-level version or edition. As a national leading provider of Sage 50 professional services we have performed hundreds of updates to the most recent version.

Sage 50 2019

Training:

Learn how to use the software quickly and efficiently Sage 50 Training Classes.

Consulting:

We can help convert your lists and balances to make the transition or upgrade easy for you.

Spend more time on your business, less time on your books give us a call or visit www.jcscomputer.com

 

#sage50, #sage502019, #sage50software, #sage50nearme, #sageupgrade, #sage50upgrade

Timeslips Training

Sage 50 Physical Inventory Count

Sage 50 Physical Inventory count

EZScanIt is the Sage 50 Barcode Add-ons for Sage 50 Quantum by Sage Software

Maximize your performance With EZScanIt Inventory Management Software. This software is designed, fully integrated and made just for Sage 50cloud. This application works with all your Sage 50Cloud information. It reads inventory items, sales orders, purchase orders and comes with the ability to print barcode labels. Using this software you can get work completed quickly and manage your Sage 50 inventory in a snap. Visit Sage 50 Support to view additional information on support and training and Sage 50 barcode scanning.

This is the only barcode scanning software on the market that uses your Sage 50 data. Yes, the same data you have already set up in your Sage 50cloud software package. This Sage 50 Barcode Inventory System is an affordable inventory management software. It will help you reduce costs. You can increase efficiencies, minimize your time and efforts using sage 50cloud physical inventory count

EzScanIt Demo

This video revels how to use EZScanIt Sage 50 Barcode add-on for Sage 50. You can ship, receive, print labels and perform physical Counts. Other names for this software include:

  • 2020 Sage 50 cloud
  • 2019 Sage 50C
  • Sage 50
  • Peachtree Accounting
  • Sage 50 Bar Code Scanner
  • Bar Code Scanning Software
  • Sage 50 Inventory Management

Sage 50 BarCode add ons for Sage 50. Ship, receive, print barcode labels and perform physical inventory counts for Sage 50 software using your data from your Sage 50 company data files. No need to set up a second software application and maintain two sets of data files.

Advantages:

Most businesses write the counts on paper and then calculate the differences. They they manually enter the adjustments. A barcode scanner allows you to more quickly take a physical inventory count, update the inventory adjustments into Sage 50 and print a physical inventory variance report. If you want to easily finish your work you can use these features to help you get it done.

Accounting Business Solutions by JCS provides support, training and consulting for Sage 50 all versions. Put our 30 years of experience to work for you and we can share with you best practices for using Sage 50 Accounting software. For more information visit www.jcscomputer.com or call 800.475.1047

 

Sage Timeslips Training

sage 50 barcode scanner, sage 50 barcode scanning, barcode scanning sotware, sage 50 add ons, sage 50 barcode, sage 50 inventory management

Sage 50 Barcode Add Ons

#sage50barcodescanner, #sage50barcodescanning, #barcodescanningsotware, #sage50addons, #sage50barcode, #sage50inventorymanagement

Sage 50Cloud PayPal Stripe

Sage 50Cloud PayPal and Stripe

Sage 50cloud now provides payment options using PayPal or Stripe

So why not get paid faster and improve your business cash flow and leverage this feature if you are using Sage 50cloud. You can sign up now to use PayPal or Stripe for your small business. Payments can be accepted online, on a mobile device, in an app or in person using this feature. Consider this new service because it is used inside Sage 50Cloud. This new integration makes getting money from your customer simpler and adds to the current payment options just making Sage 50Cloud a better small business solution.

Recording payments in Sage 50cloud

Apply a Customer Payment to an Invoice. From the Tasks menu, select Receive Money. Enter a deposit ticket ID that can easily represent the type and source of payment. Lookup, enter or select the customer ID. Enter a check/reference number that will help identify the receipt (for example, the customer’s check number). Or you can now select PayPal.

Manage all your payments in one place and eliminate the hassle of manual data entry. Activate built-in payments and:

  • Accept credit card payments on invoices directly in software
  • Automatically post to the General Ledger —no manual entry
  • Sync online or onsite payments directly to the General Ledger
  • Feel confident payments are secure

Customers can easily signup to start using PayPal or Stripe and accept payments using  a business account. This feature makes it one of the most flexible methods of digital payment. Set up your PayPal business account, activate this in Sage 50Cloud and you are ready to go. Sage 50cloud customers can start taking for payments for new or existing invoices right away.

This new integration between PayPal or Stripe and Sage 50cloud giving your businesses more choices for accepting payments from your customers. For businesses like yours this new feature can be setup within minutes, activated and in put into action.

Review the latest versions of Sage 50Training classes

Sage Timeslip Training

Sage 50Cloud

Sage 50Cloud

Standard Crystal Reports in Sage 50 and Sage 50cloud

Which standard Crystal Reports are included in in Sage 50? 

Standard Crystal Reports included in Sage 50 include:

  •       Aged Payables v9
  •       Aged Receivables v9
  •       Customer Balance Graph v9
  •       Customer Detail List v9
  •       Customer Sales by Item v9
  •       Customer Sales by Month v9
  •       Inventory Labels v9
  •       Items Sold by Month v9
  •       Purchases by Unit Price v9
  •       Vendor Balance Graph v9
  •       Vendor Detail List v9
  •       Void Check Register v9

If you would like to learn more about standard Crystal Reports in Sage 50 and Sage 50cloud, Accounting Business Solutions by JCS offers a Sage 50 Manufacturing/Sage 50cloud Manufacturing training class, as well as a Crystal Reports for Sage 50 class. For Sage 50 support and training, call us today at 800-475-1047 or email us at solutions@jcscomputer.com.

Create Purchase Orders from Work Tickets in Sage 50

Create Purchase Orders from Work Tickets in Sage 50

How do you autofill or auto create Purchase Orders from work tickets in Sage 50? 

Sage 50 allows you to set up Inventory Item Defaults to auto create purchase orders in Sage 50 behind the scenes. The Ordering tab of this window has options that let you enable the auto-creation of POs for:

  1. drop-ship transactions
  2. non-drop-ship transactions
  3. work tickets

Important:For auto-creation of purchase orders to work, your company must be using the real-time posting method.

You can treat each auto-created purchase order just as you would a manually created one. You can edit the purchase order, print it, or e-mail it to a vendor in the Purchase Orders window.

Note: Even if your company is set up for auto-creation of purchase orders, Sage 50 will not automatically create POs for recurring customer invoices. Instead, you will have to manually generate POs for any inventory that you need to reorder as a result of recurring invoices.

To auto create purchase orders from work tickets in Sage 50, the following criteria must be met:

  • Each item must be set up in Maintain Inventory Items with a preferred vendor.
  • The user who is entering the transactions listed below must have access rights to add Purchase Orders.
  • The quantity ordered of one or more of the items must cause the quantity available as of the transaction date to fall below minimum stock levels.

If these conditions are met and your company is set up to auto create purchase orders in Sage 50. Sage 50 will automatically create a purchase order each time a work ticket is saved. In addition, to ensure that auto-creation works most effectively, each item in Maintain Inventory Items should be set up with a minimum stock level and minimum reorder quantity. Sage 50 will auto-create purchase orders from Work Tickets for inventory items that fall into the following item classes only

  • stock
  • substock
  • serialized stock.

If you would like to learn more about how to perform this smart function using Sage 50 and Sage 50cloud, Accounting Business Solutions by JCS offers a Sage 50 Manufacturing/Sage 50cloud Manufacturing training class. For Sage 50 support and training, call us today at 800-475-1047 or email us at solutions@jcscomputer.com. Sage 50 Training Class. 

Sage Timeslips Support

Update Work Tickets in Sage 50 and Sage 50cloud

How do you update work tickets in Sage 50? What are work tickets in Sage 50 used for?

From time to time, you will need to update work tickets with your progress. Follow the steps below to update a work ticket.

  1. From the Tasks menu, select Work Tickets. The Work Tickets window appears.
  2. Click the Open button and select the ticket that you want to update and click OK. The selected work ticket information appears in the Work Ticket window.
  3. Update any of the information that has changed on the work ticket.
  4. If you have finished or received items in the component list, select the corresponding Finishedcheck box and enter the Act Hours, if you are tracking hours.
  5. Then, click Save. After you have marked one item in your component list as finished, your work ticket is given a status of In Progress.

If you would like to learn more about how to update work tickets in Sage 50 and Sage 50cloud, Accounting Business Solutions by JCS offers a Sage 50 Manufacturing/Sage 50cloud Manufacturing training class. For Sage 50 support and training, call us today at 800-475-1047 or email us at solutions@jcscomputer.com.

Print a crystal report in sage 50, sage 50 crystal report, crystal report sage 50, sage 50 intelligence reporting

Print a Crystal Report in Sage 50

Print a Crystal Report in Sage 50

How to use SAP Crystal Reports with Sage 50

How to print a Crystal Report in Sage 50 – For older versions of Sage 50 to print a Crystal Report in Sage 50, you must preview the report and print using a Crystal Reports license. If you currently have a license for Crystal Reports and Sage 50 then follow these simple steps to print a Crystal Report in Sage 50:

  1. In Sage 50, select ReportsCrystal Reports from the main menu.
  2. Highlight Vendor Detail List and click the Preview button or double-click Vendor Detail List.
  3. Click OK to continue. The report opens in Crystal Reports.
  4. Select Report, Refresh Report Data to ensure that the report is displaying the most recent information.
  5. Ensure that Use current parameter values is selected and click OK. The report refreshes.
  6. Select File, Print, Printer.
  7. A message appears, asking if you would like to use the default printer. Select Yes. Then, click OK to print the report. One page of the report is shown on the next page

Crystal Reports

Yes, Crystal Reports is one way to extract data from Sage 50 and we can train you on the process. You would not need to have the product prior to the  training. However, we have found that on-line training without the ability to immediately practice what has been demonstrated has a lower retention rate. You will also need to gain experience by practicing. The final element is to be able to find the appropriate data tables and fields to retrieve the data for use within those reports.

Please note, that although Crystal Reports can still be used with Sage 50, Sage has not included Crystal Reports as part of the Sage 50 product since 2014. A license has to be purchased separately. It is generally not recommended as the external report writer of choice unless reports were created prior it’s being removed from the product. It is most often required when these reports are still needed or new reports are required that cannot be created using the currently support Sage Intelligence external report writer.

Sage 50 Advanced Reports Options

  • Crystal Reports
  • Financial Designer
  • Sage Intelligence

Choose printing preference

The first step is to confirm the types of reports that you are expected to produce. This will confirm that Crystal Reports in the most appropriate choice for those reports. Other reporting options include

  • The built in report designer
  • Financial statement designer
  • Built in forms designer
  • Sage Intelligence

Print a Crystal Report in Sage 50

If Crystal is the most appropriate choice for an external report writer, I would be glad to set up an online training session for you. It is always helpful to know the reports you wish to produce, so I can choose one as example during training to give you experience in determining the tables and fields to create a specific report.

Learn More

Give us a call 800.475.1047

Print a crystal report in sage 50, sage 50 crystal report, crystal report sage 50, sage 50 intelligence reporting

 

Sage 50 data tables for use with Crystal Reports

Journal Header Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: JRNLHDR.DAT

JRNLHDR.DAT has one record for each transaction entered in Sage 50. There is a one-to-many relationship between header records and row records. Each header record can have any number of related rows.

Note: Memorized Transactions are stored in StoredTransHeaders.DAT. All the field names are the same as in JrnlHdr.DAT.

Indexes and Their Uses

JRNLHDR.DAT has 22 keys, as follows:

0 = By JournalKey (Shadow, Journal, Period, TrxNumber, Partner.

1 = By PostOrder

2 = By Posted and then by PostOrder

3 = By LedgerKey (Module, CustVendEmpID, Date, and then by PostOrder

4 = By Reference

5 = By Date

6 = By Journal, then by Date, then by Reference, then by LedgerKey.RecordNumber, and then by PostOrder..

7 = By JournalKey_Journal, then by JrnlKey_Per, and then by Reference.

8 = ByGUID

9 = By Journal, then by Reference.

10 = By Journal, then by Completed Date

11 = By ReceiptNumber

12 = By Journal, then by MainAccount, then by Deposit Ticket, and then by Date

13 = By Journal, then by Extended JournalType, then by Date, then by Reference, then by CustVendEmpID, and then by PostOrder

14 = By Journal, then by Date, and then by PostOrder

15 = JrnlHdrByJrnlCVEReference

16 = JrnlHdrByElectronicDateSent

17 = By Recur Number, By Date

18 = By JournalEx, then by Date, then by Reference, then by LedgerKey.RecordNumber, and then by PostOrder

19 = RecurNumber

20 = JrnlHdrByElectronicDateSent

21 = By JournalKey_Journal, then by CustVendId, and finally by Date

22 = ByLedgertKeyModule, then by CustVendEmpID and then by Date

If you would like to learn more about how to print a Crystal Report in Sage 50 and Sage 50cloud, Accounting Business Solutions by JCS offers a Sage 50 Manufacturing / Sage 50cloud Manufacturing training class, as well as a Crystal Reports for Sage 50 class. For Sage 50 support and training. Sage Timeslips Training

email us at solutions@jcscomputer.com

X