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.

sage 50 bank reconciliation

How to Run an Audit Trail Report in Sage 50

What is an Audit Trail Report in Sage 50?

The Audit Trail Report is a useful report which helps users locate and correct Sage 50 errors by offering them a detailed chronological listing of all changes made in their Sage 50 company file. This useful report shows the date and time of the modifications, as well as the user who made them. The Sage 50 Audit Trail offers unique customizable columns and can assist you in pinpointing Sage 50 data errors.

Month End Close Checklist for Sage 50

 

How do you run an Audit Trail Report in Sage 50?

To run an Audit Trail Report, follow these steps:

  1. Select Reports & Forms

Audit 1

 

2. Select Company, then select Reports

Audit 2

 

3. Select Audit Trail Report

4. When the report opens, it defaults to today’s activity.  Click Options (Gear icon) to select your specific date range.

Audit 3

 

Are you having trouble with your Sage 50 or Sage 50c software? The certified Sage consultants at Accounting Business Solutions by JCS offer Sage 50 training, support, and data repair. Our experienced Sage 50 experts can help get rid of your Sage 50 error  messages, including those which can be fixed with the Sage 50 Audit Trail Report. To get started with a Sage 50 consultant today, call us at 800-475-1047 today or email us at solutions@jcscomputer.com.

 

New in Sage 50 and Sage 50c – U.S. 2018.1 – 800.475.1047 – Support – Training – Consultant – Reseller

New in Sage 50 and Sage 50c – U.S. 2018.1 – 800.475.1047 – Support – Training – Consultant – Reseller

The new features provide flexibility to keep your office connected to the cloud! Features include:

  • New Cloud & Mobile Navigation Center
  • New Sage Bank Feeds Auto-Reconciliation Features
  • Improvements to Sage Contact
  • New Sage Dashboard Office 365 app

Cloud and Mobile Navigation Center

The Cloud and Mobile Navigation Center connects services via the cloud and allows for remote company data sharing. Accessible from the file menu, Office 365, Sage Drive and Sage One are all integrated. Beginning with the release of Sage 50c, the Cloud and Mobile navigation center are included. Your data is securely shared through the cloud without compromising data security. There are many features included with this new navigation center.

Sage Bank Feeds – Auto-Reconciliation Feature

Sage now offers the ability to link your bank account to sync bank and credit card transactions in order to streamline the process of reconciling these accounts. This feature helps eliminate errors with manual data entry while promoting accuracy to match transactions processed by your bank or credit card. The setup is easy through the account reconciliation window. Capture up to 2 years of historical bank records. Once the bank feeds are downloaded, Sage 50c will automatically match the transactions previously recorded to clear.

Sage Contact Improvements

Again, this feature is integrated with Microsoft Office 365 to allow you to view the detailed information about Sage 50c customer and vendor contacts in the Office 365 Mail app and desktop version of Outlook. There is a comms tab that provides the view of previous communication with vendors/customers to easily review history of communications and there is a notes tab to track communications and share notes with other users.

Sage Dashboard – Office 365 App

This is a new application offered in Sage 50/50c that integrates with Microsoft 365 that will allow you to view Revenue-Expense information, Aged Payables and Aged Receivables directly in Office 365. As long as you have access to the web, you will be able to view these features through a series of interactive charts and graphs. This feature provides you the ability to view critical data anywhere, anytime. The app will sync automatically. Examples of these features include Overdue Sales by Period shown on a bar graph for the last 12 months with the ability to drill down on a particular month. An Accounts Aging Pie chart is also available displaying the largest and oldest accounts as the larger pieces of the pie and the smaller piece listed as other with the remaining past due customer accounts. The pie chart can also be drilled down on by selecting a customer. On the Payables tab, the bar graph will display Overdue Purchases by Period and the Pie chart displays Accounts Over 90 days past due. The final tab is Revenue and Expenses displayed for the past 12 months in bar graphs.

For more information on Sage 50 and Sage 50c, give one of our professional consultants a call 800.475.1047 www.jcscomputer.com

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”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

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

Peachtree Year End Check List – Make a Historical Company – 800.475.1047 – Consultant – Support – Training – Reseller

How to make a historical company in Sage Peachtree

Are  you on an older version and need to upgrade

Year End Check List

Consultant – Support – Training – Reseller

  1. Login to the live company and backup company data
  2. Create a New Company “2017 History” (Current year to archive)
  3. Restore the backup into the 2017 History Company
  4. Go to Maintain -> Company Data -> chance the company name to “2017 History” company
  5. Log in to the Live Company
  6. Confirm all old Sales Orders have been closed
  7. Confirm all old Purchase Orders have been closed
  8. Print the following reports using 12/31/2017

– General Ledger Trial Balance

– Accounts Payable Aging

– Accounts Receivable Aging

– Inventory Valuation

– Payroll YTD Earnings

  1. Go to Tasks -> System -> Year End Wizard

 

For more information on Sage Peachtree give one of our professional consultants a call 800.475.1047 www.jcscomputer.com

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”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

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

2018.0 – Sage 50c Exclusive Office 365 Release Features – 800.475.1047 – Training – Support – Consultant – Reseller

2018.0 – Sage 50c Exclusive Office 365 Release Features – 800.475.1047 – Training – Support – Consultant – Reseller

Sage Intelligence Reporting with Office 365:

SI Reporting reveals the power of Sage 50c data into Excel. Customize and build powerful report using simple drag and drop design. Now with the ability to publish financial reports to the cloud and access them on your device to provide a deeper understanding to your business insights.

Sage Capture with Office 365:

Capture a receipt or record a transaction then post it to Sage 50c using any mobile device or tablet. Images are stored automatically in OneDrive so you won’t lost a document or receipt again. The Sage Capture App can be downloaded for free from the Apple and Android App stores!

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”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

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

2018.0 – Sage 50c Release Features – July 2017 – 800.475.1047 – Support – Consultant – Training – Reseller

2018.0 – Sage 50c Release Features – July 2017 – 800.475.1047 – Support – Consultant – Training – Reseller

User Interface Modernization

Sage 50 is calling this a Facelift which has been long overdue. They have updated the Navigation Centers to ease use while keeping the functionality that we all know.

Sage 50c and Traditional:

AP Automaton provided by Beanworks

Beanworks offers a cloud-based accounts payable automation solution that helps companies streamline their invoice to payment process. Invoice routing is automatic and provides the ability to review and approve online. Also pay invoices via automated check, wire, EFT/ACH or virtual credit card.

This feature add-on and partnership will be available to Sage 50, Sage 100 and Sage 300 customers. Sage 50 Quantum customers with 25 or more users will get an immense amount of satisfaction and see increased productivity using the AP Automation.

For more information on Sage 100 give one of our professional consultants a call 800.475.1047 www.jcscomputer.com

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”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

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

 

2017.1 Features in Sage 50 and Sage 50c – 800.475.1047 – Reseller – Consultant – Training – Support

2017.1 Features in Sage 50 and Sage 50c – 800.475.1047 – Reseller – Consultant – Training – Support

sage-1sage

Four Main Features for Sage 50c

  • Integrates with Microsoft Office 365
  • Mobile and Online invoicing and payments
  • Sage Drive read only access
  • Automatic cloud backup using Microsoft 365

Features available for all versions of Sage 50 and Sage 50c

  • Web mail support
  • Automatic activation of Sage Payroll accounts

Sage 50c Exclusive Online Invoicing and Payments

Customers with Sage 50c are now able to create and send invoices online using computers or the mobile application.  Recipients can use the Pay Now link on the invoice to pay directly and easily online. This feature will help simplify the billing process and shorten the payment cycle.

  • Sage 50c customer records and general ledger accounts are uploaded to Sage One, however no service items, sales tax codes or inventory is uploaded
  • Sage One is available for Sage 50c customers for free. Activation codes are emailed to all customers on November 16, 2016. New customers will receive the activation code when purchased or upgraded to Sage 50c.
  • Sage 50c customers can now download open invoices into Sage 50c from Sage One
  • Paid invoices, Sage 50c customers must manually record receipts into Sage 50c
  • Once Sage 50c customers create a Sage Once account, entry of inventory and service items must be manually entered. Then the ability to generate and send online invoices from Sage One is available using either their computer or the mobile app
  • Pay Now link is available for recipients/payee using PayPal from emailed invoices. For customers that have SPS Merchant account can choose the option to receive a credit or debit card payment
  • Sage One Accounting offers Online Invoicing and Payment ***

*** Online and mobile invoicing requires a Sage One subscription for integration. This is a one way integration and will require users to manually enter their inventory and service items into Sage One; customer records and general ledger accounts will be entered for them. Only customers on the latest release of Sage 50c Accounting have access to the Sage One integration. If customer cancels the Sage One integration service, to maintain access to Sage One, customer must set up separate billing. Not all Sage One features are available on the mobile app. Mobile devices sold separately and require a data plan. Data access is subject to cellular provider network availability and occasional downtime due to system maintenance.

Sag 50c Exclusive Microsoft Office 365 Integration

Staged releases for Sage 50c customers in the U.S., Canada and the UK will provide features integrated with Microsoft Office 465.

Microsoft Office 365 automatic cloud backup* (c-line exclusive)

This feature provides Sage 50c customers the ability to store and retrieve company backup files online securely through the Office 365 integration.  This feature was ranked Number 1 in recent survey of new features.

* Requires Microsoft Office 365 Business Premium license, available through Microsoft.

Sage 50c Exclusive Read-Only Mode

This allows additional Sage 50c users to access the shared company in a read-only mode while active users has the ability to still work in the company file.

Web mail support – Available to both Sage 50 and Sage 50c Customers

Customers can now utilize their web-based email services (e.g., Gmail, Yahoo, Hotmail, Live, AOL, and Office 365, etc.) when emailing transaction forms such as invoices or receipts from Sage 50.

Automated Sage Payroll In-Product Activation – Available to both Sage 50 and Sage 50c Customers

Sage Payroll Services customers will now have automatic in-product activation of their payroll account. This improves and automates the current manual process that requires the Sage sales colleague to generate an activation code and email it to the customer who must then enter it into Sage 50. Now Sage Payroll customers identify themselves in product and the activation code is entered for them.

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”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

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

Sage 50 – Questions for your Network Server – 800.475.1047 – Support – Training – Consultant – Reseller

Sage 50 – Questions for your Network Server – 800.475.1047 – Support – Training – Consultant – Reseller

While this list can be extensive, it is extremely important to have more information to purchase, upgrade, or update your Network Server adequately to meet your businesses current needs and future needs.

  1. Do you have a current server?
  2. Is the new server replacing your current server or is it in addition to your current server dedicated to Sage 50?
  3. What are the specifications of your current server?
    1. CPU –
    2. Memory –
    3. Disc Space (total and available) –
    4. Backup Technology currently in place –
  4. Are the workstations members of the domain or running as peer-to-peer?
  5. Is the server running Active Directory Domain Services or acting as a Member Server?
  6. What services are currently configured on the server?
    1. Examples: DNS, SHCP, File Sharing, Network Printing, Terminal Services, Email, etc.
  7. Are you using any network-accessible or network-wide applications?
    1. Example: Server-managed anti-virus software to monitor connected workstations
  8. How many workstations are on the network, potentially accessing resources of the server?
    1. Example: Access to shared folders, network printing services, managed anti-virus software, etc.
  9. How many users are on the network?
    1. This could be differ depending on multi-user PC’s, multiple shifts, etc.
  10. What backup technology are you using?
    1. Examples: Removable hard drive, tape/cartridge, cloud solution, etc.
  11. What is your backup schedule and policy?
    1. Examples: Every night, once a week, full or incremental backups, month-end archives, etc.

Questions related to your networking environment that may or may not have impact on your server

  1. Who is your internet server provider?
  2. What are you upload/download speeds?
  3. What equipment and/or technology are you using for perimeter security?
    1. Examples: Firewall, routers, etc.
    2. Cisco, Sonicwall, ISP-Provided, etc.
  4. What equipment do you use for your network topology?
    1. Examples: switches, print servers, wireless access, etc.
    2. Are they Switch(es) 100mbps or Gigabit speed?
  5. Do you have any peer-to-peer networking or only client-server?
    1. Examples: Peer-to-Peer – engineering can access secretary’s hard drive or printer. Client-Server – only device providing resources is the server

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”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

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

Sage 50 Accounting – Receiving a Purchase Order flowing through Shipping and Completing a Sales Order – 800.475.1047 – Support – Training – Consultant – Reseller

Sage 50 Accounting Bar Code Software and Bar Code Labels

Sage 50 Accounting – Receiving a Purchase Order flowing through Shipping and Completing a Sales Order – 800.475.1047 – Support – Training – Consultant – Reseller

Wondering how Bar Code Software works?  Can your business benefit from using it?  Do you have serialized items you need to keep track of?  We’ve got the details for you.

The following will explain how Bar Code Software works with a handheld device incorporating purchase orders, receiving in purchase orders, applying purchase orders to a sales order and assigning serial numbers to items that include them.

1

For this demonstration we are using EZ Scan Software with Motorola MC75A handheld

Starting with purchase orders, logged into your company on a handheld device you’ll be prompted to choose a vendor you wish to receive a purchase order in from or the option to choose the purchase you wish to receive in either using the drop down arrow or manually key in the purchase order number with the keypad on the handheld device.  The handheld is programmed to only see open purchase orders.  So if the order has been fully received in, it will not show up as an option on your handheld.  If the purchase order was partially received, the handheld will only give you the options to receive in what is still open.  After choosing the vendor and purchase order number, the system will prompt the date in which you received it or entered it in.  Also on the screen of handheld device is a ‘Receiver #’ space to add the packing ticket or referenced received number in if you choose to reflect on receipt.

12

After choosing the vendor and purchase order you wish to receive in, the handheld will display the purchase order just as it is reflected in Sage 50.  You can view the quantities to receive, what is open on the purchase order, how many of that item was ordered, unit of measure for that item, the item description, serialized item or not, and the line number in which the item is listed on the purchase order. You have the option to ‘receive all’ or an option for ‘items’ which allows you to select a certain line item and adjust the quantity received if it does not match the original quantity of the purchase order. There is also an option for ‘notes’ which would be for example “The box was damaged.”  For serialized items that you receive in, select the ‘items’ option, then enter the quantity you wish to receive, then at the top of the screen you’ll see an option for ‘SER.’ Once selected it will open a new window where you can actually scan the barcode of the item and it will add the serial number associated with that item in the field. If you wish to assign your own serial number, you’ll click the box that says ‘ADD’ and blank consecutive serial numbers.

Sage 50 currently does not yet have the ability to direct right into your Sage 50 software, however, there is a utility that runs on your server that transfers the data back and forth between your Sage 50 data and the handheld device. Sage 50 and your handheld device will sync every 5-7 minutes to transfer data back and forth.

The handheld will also give you the option to view sales. Once selected, a new screen will pop up as ‘ship order.’ Select the customer from the drop down menu or key in the customer.  Choose the Sales Order you wish to view with the drop down option or if you know the Sales Order number you wish to view you can key it in.  If there is a Customer Purchase Order number you wish to include on the shipping information you can enter it (from the Sales Order created). There is an option for ‘Ship Via’ to select a shipping method, enter the ‘Ship Date’ and finally you have the option to enter a freight amount.  There is an option to review the bill/ship to information for customers that have more than one location or multiple addresses. There is an option to add notes either on the Statement, a Customer Note, or an Internal Note you can add those as well. Click save and it will bring you back to the Ship Item window.

12

Now we are ready to ship the item. By selecting items the new window will come up for ‘Ship Item’s Detail’ which gives the option to enter in the quantity you wish to ship and assign serial numbers for those items being shipped. Select SER box and that will bring up all the available serial numbers you have available to choose from or select the serial numbers that were scanned in upon receipt of the purchase order. There is an option for ‘Audit’ which you can select to view any open or pending items that have not yet been received/shipped/included on that transaction. Once complete, click save.

3

Back in Sage 50, you can view the open purchase orders to see what’s been received and completed. Same goes for Sales Orders. When the Sales Order is complete and ready to be invoiced, you’ll see on the Sales Order screen a button to view ‘Serial.’ By selecting that, you’ll be able to view the serial numbers of the items for that customer that were packed and/or shipped.

To view this demonstration via webcast, visit

For more information on Sage 50 give one of our professional consultants a call 800.475.1047 www.jcscomputer.com

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”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

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

X