Sunburst Database

Contact us at: (208) 725-0040
info@sunburstdatabase.com

Software

The software from Sunburst Database provides solutions for various industries. The programs and development techniques have been refined over the past 20 years to create reusable components for successful applications.

The software is configurable for specific needs, or can serve as the basis for a solution after further modification. The programs run under Microsoft Access and can be installed on a company network or hosted on an Internet server.

Sunburst Database uses base systems which have already been created and modifies them to match client needs through configuration, additional coding, and add-on modules. Following are systems currently available, and some examples of their current use.

Lean Manufacturing DMS – This system manages a small manufacturing system from sales order through production, and includes an account receivables module to track invoices, payments, and account balances. There is a complex system to drive work orders and purchase orders from the Bill of Materials for each sales item. Contact us to see samples.

Job Estimate Tracker DMS – This system provides job costing software for engineering firms and construction service companies to manage estimating, time and materials charges, billing, and accounts receivables components. Numerous modules developed over the past ten years have been assembled to manage client contacts, estimating, work orders, time-tracking, purchase orders, vendor payments, inventory, and customer billing. Current users of various versions of this system include painting, roofing, plaster, and plumbing companies. The system integrates with QuickBooks tables to monitor invoicing. Contact us to see samples.

Rental Tracking DMS – This system manages rentals of equipment. It tracks the availability of equiment for any given day by analyzing reservations and multi-day rentals. Contact us to see samples.

Investors Quarterly DMS – This system manages Investors and Assets to help track financial investments, like real estate private equity. Performance is computed from dividend and interest payments. It automates the production of Quarterly Reports, which can automatically be attached to emails as PDF files. Contact us to see samples.

Patient Chart Tracker DMS – This system manages patient medical summaries to help doctors quickly view the essential patient chart data necessary to provide quality medical care. The software can act as a stand-alone program or be integrated with standard medical accounting packages. For many doctors, their EHR/EMR medical billing software makes it difficult to quickly access important health information because the billing software is mainly designed to comply with reporting requirements for government or insurance companies. Contact us to see samples.

Event Response Tracker DMS – This system manages the emergency responses for an organization that has numerous paid or volunteer responders. It can help with tracking of memberships and donations, and can be expanded to provide billing and invoices based on timesheets and materials used in a response. Contact us to see samples.

Adventure Tour Tracker DMS – This system has been in use for over ten years at a local helicopter skiing company. It has modules for managing clients, tours, flight manifestos, invoicing, payments, and other accounting functions. The software has been upgraded to take advantage of some of the newer features in the family of Sunburst Database systems, such as management of documents and broadcast emailing for marketing. Contact us to see samples.

Bank and Financial Regulatory Reporting – These products are co-developed and co-marketed with partner Data Informatics (DataInformatics.com). The Bank Informatics software is integrated with the Import Templates module to automate data feeds from diverse sources. Complex stored formulas are applied to the merged data to produce outputs that match regulatory reporting requirements. Bank Informatics resides on your server under your control, replacing complicated Excel spreadsheets and cumbersome core processing reporting modules.

--------------------------------------------------------------

The various complete systems are integrated with modules that perform specific functions. These modules are well tested and can be added to new custom systems. Examples include:

Client Contact Tracker – This module manages contacts of various types, such as customers, vendors, or staff. It includes contact reports, search and filtering, data export, and broadcast emailing.

File Tracker DMS – This module manages files in Windows folders that are linked to records in the database. It allows users to open a file linked to a database record directly from the database application while viewing the record. Users can open files of any type, like a Word document, Excel spreadsheet, PDF document, or image file. The files can be viewed, edited, or printed without needing to leave the database program. This module is usually integrated with the Client Contact Tracker, but can work with other data tables such as jobs.

Import Templates – This module transfers data from one system to another. Using configurable templates, the fields in a record-based source can be mapped and converted for migration to another destination. The source records can be an SQL database, accounting program, Excel spreadsheet, or text file. The destination can be another database, spreadsheet, or program.

Salesforce Migration  – This module uses the algorithms of Import Templates, but with the goal to export data from a Legacy source and convert the records for import into Salesforce. Special subroutines convert standard data to the formats acceptable by Salesforce. The legacy source records might be an accounting program, a database providing an ODBC connection, or spreadsheet files.

Customer Need

Software Components