Accounting

Accounting measures and evaluates financial information for a business or an individual household, such as assets, liabilities, revenue, expenses, and more. Accounting professionals are often in charge of payroll, retirement plans, inspecting financial records, allocating resources, and ensuring the balance sheets of the organization are correct in order to properly inform business decisions.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hey, we have been having a strange problem with our Quickbooks POS ver 13 multi user installation in a club setup (4 machines). Customers have to recharge their accounts before ordering and the big problem we have is discrepancies between current and available balances. However,the sale transactions are posted in real time but the balances take seem time to synchronize(happens  to a random member account irregularly ) and we have changed the LAN routers and cabling and the problem is still persisting. The charge to account is posted after some delays of a few hours. We have integrated the solution to Quickbooks premier for financial exchange. Our company file is 500MB big and the connectivity tool doesn't post any errors. The environment is available for remote access any time. Any pointers?
0
Cloud Class® Course: Ruby Fundamentals
LVL 12
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

QuickBooks - all versions - DB Mgr issues and MultiUser mode plus simple access to a company file on a Server.

I've read article after article and  they all give the same solutions over and over - which of course are valid.  Open ports on firewall, exclude AV from scanning QB folders, share permissions, etc.
Although QB is a fantastic accounting program for the small business, its data structure and sharing is something else.  We have QB database mgr installed on servers ranging from Microsoft 2008/2012/2016 domain controllers with Microsoft DNS, dedicated QB member servers (No DNS), Windows 7/10 PCs with DB mgr, etc.  All experience the same issues over and over.
The problem:  Either cannot switch to MultiUser mode or cannot access a specific company file.

Our solutions, depending on which platform QB DB Mgr is installed on is basically to perform a "Scan" from the DB Mgr and once its complete, all is good.  Of course on DC's we have to stop DNS (or modify QB to look at other ports that don't conflict) or restart the QB service or just do the scan.  We do find that if we open the QB program on the DB Mgr server and open a company file, there is never an issue but that is not something you can leave because certain functions require QB to be in single user mode to perform.  Even if we disable any firewalls on the DB servers we still get issues.  Many times, on standalone servers, running the Scan to search for company files give a network error.  Most of the time we …
0
Hyper-V Storage Recommendation for small enterprise required.

I have a customer that is a 25 seat accounting practice.  Currently they have a server that is 4 years old, dual Xeon CPUs, 72GB of RAM.  Storage is a RAID 6 array of 8 15K 300GB SAS hard disks.  There are 2 years remaining on the warranty.  The server is a Windows 2012 Hyper-V host.  There are 3VMs, a DC, a file server and a RemoteApp server.  The server provides more than adequate compute resources but is running out of storage space.  One of the file server volumes has already been moved to a Synology NAS connected via iSCSI.  Even with that, storage on the server is becoming severely constrained. Storage requirements are only going to grow as the client is moving towards "paperless" operation.

I don't know much about storing VMs outside of the box that they are hosted on, but it seems attractive to move the virtual disks to some sort of network based storage. Easily scalable storage, and when the time comes the ability to replace the Hyper-V host hardware and simply migrate the VMs without disturbing the VHDs.  For a smaller organization like this it seems (from my limited research) that a true SAN is not going to be financially viable.  Is it feasible to use NAS boxes to store VMs or am I going to be better off just recommending replacing the entire server?

DR is handled by a 4TB Datto Siris, so building a multi node cluster really isn't necessary either IMHO.  I know there are some small scale …
0
Hi

Experts C#

Help me how to add a namespace to my existing project in C#. I want to add this new namespace :

namespace autocomplete_controls_csharp

Where do I insert the above name space ,the idea here is that I want to auto complete the combo box on my form instead of using a button to fill it in, those who have experience with MS access will agree with me that once a combo box is set the data is also auto filled in. Below is my simple project:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Accounting
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(@"Data Source=USER\SQLEXPRESS; Initial Catalog=CaPremier; Integrated Security=true; User ID=user\admini");
            con.Open();
            SqlCommand cmdinsert = new SqlCommand("Insert into Customers values('" + txtCustomerID.Text + "', '" + txtCustomer.Text + " ','" + txtAddress.Text + "' )", con);
            cmdinsert.CommandType = CommandType.Text;
            cmdinsert.ExecuteNonQuery();
            con.Close();
            MessageBox.Show("Data Inserted");
        }
    }
}
0
Hi Experts,

My QuickBooks company file is damaged and not opening. Please help me to fix the problem. I have tried QuickBooks file doctor but didn't work.
0
Hi

I have built a simple accounting system in Access  and modelled it around Northwind. I have
modelled the inventory part very much around Northwind. I now need to build a Bill of Materials component.

Does anyone know whether Northwind does this? Any recommendations on how to go about it would be greatly appreciated.

Thanks
0
Artificial Intelligence
The Technological innovations of machine learning and AI will shape the world of accounting into a better and enhanced form.
0
Hi All,

I hope you can all help. Those with a foundation of security would be especially welcome; however opinions always offer some weight, even if from a non IT background.

I have a question regarding IT Security and Non Repudiation.

I have been in a work environment recently where I have performed the following on a whole.

1. When first starting everyone in the company was using one general admin account with "all power" permissions to administer the network.
I implemented a policy to make sure individual admin accounts where created for each IT Person; for accounting purposes.
All 3 personalized admin accounts setup have equal and full administrator permissions on the domain network.

2. When starting all passwords, including admin accounts etc.. where stored in an excel spreadsheet.
I moved this to an encrypted lastpass database; that was moved to a central platform later on for on the road IT staff.
Everyone was given access to the centrally system; however due to myself being occupied with a specific client; left management to another internal IT staff member.

3. The client which I did the above for has kept passwords of all its staff in an excel sheet; which I have advised against; however my reasoning has been ignored for control and I guess what might be a lack of trust of our IT company.


I have recently complained to my Directors(no managers, small company) about illegal activities that were taking place; such as providing unathorised …
0
hi guys if you have any experience about installation of Peachtree accounting software on Ubuntu software please share it your  experience
I tray to install Peachtree accounting software on Ubuntu i cant  please  support me.
0
My company is in the process of changing to Office 365, and one of my users has run into an Excel issue that I can't seem to overcome.

Situation:
User exports a report to Excel from our accounting software.  The spreadsheet contains several columns that has numbers set as text.  The user's solution to this is to multiply the spreadsheet by 1 and convert the cells and text to numbers. This is a Microsoft solution, although, I had never seen it used before.  

The problem is that once the file is saved and reopened Excel reports that the workbook is corrupt and needs to be repaired.  The repaired book has removed all of the letters from the spreadsheet.

Diagnostics:

Is replicated with several different reports and multiple computers
Does not occur with Office 2013 Pro Plus or 2016 Pro Plus (even on systems that crash with 365)
No error messages in Event Viewer
All Windows, driver, and Office updates have been applied
Office has been reinstalled
Excel cache and all temp folders have been cleaned out

The first option in the link to use the text to columns function, but one of the columns uses a merged cell so it won't work for the entire spreadsheet.


Thank you for your time,

Michael
0
Choose an Exciting Career in Cybersecurity
Choose an Exciting Career in Cybersecurity

Help prevent cyber-threats and provide solutions to safeguard our global digital economy. Earn your MS in Cybersecurity. WGU’s MSCSIA degree program was designed in collaboration with national intelligence organizations and IT industry leaders.

Hi
I am trying to work out how the Microsoft Access Northwind database handles credit notes at a table level?
Are they entered as negative invoices? Which tables are affected?
0
Here is why.
0
Debits & Credits have been the foundation of financial record keeping since 1494 - over 500 years. Excel is a brilliant tool for leveraging this ancient power - not least with Pivot Tables, sorting and filtering. This article seeks by illustration to offer a practical demonstration of the theory.
0
I'm using Sage 50 Premium Accounting 3-User, and trying to upgrade from v. 2017 to 2018.  
Sage has announced that v. 2017 is going into Obsolescence on Feb 28, 2018.  

Sage requires an upgrade to version 2018 in order to continue using the software, so this must be done in some form within the next week.

This would be fine, except I just discovered that v. 2018 will not install on our server.  It is an older HP ML-310 running MS Server 2008 Foundation.
Sage 50 v. 2018 requires at minimum Server 2008 R2 operating system.

I will eventually upgrade this server, but it is a major undertaking for our small one-person (me) IT department.  

I am trying to discover if there are any hidden tricks which will allow me to fool the Sage software into installing successfully on the  Server 2008 Foundation system.

If I cannot figure a way to install the Sage update on my existing server machine, I will be forced to either hurriedly buy and configure a  new server (2016 Essentials?) or just install the Sage update on a client machine for the short term.  Neither of these options are good...

What I would prefer to do is find a way to get Sage 50 working short-term, then just buy a new machine with a modern OS and take my time setting it up and porting the needed apps to the new system.

For more background:  We are a small ~50 employee company with this one old server and about 10 workstations ranging from XP to Win10.  

Other than the Sage 50 Accounting, I also …
0
QuickBooks-Hosting
Choosing the right mix of apps is very much necessary for CPAs for making the most of the latest technology through which they can boost their growth.
1
for example i need a tools to send notification for change password in user said after 30 days...
user have ability to change password by sms and ussd code
user have 2FA or MFA authenticated by sms and email and app
i need a good reporting part for create every report
i need a OTP authentication metod
i need a interface to connect to the sysloge and sysloge server
i need to portal to send notification to every user to change password in the last of manoth
0
TRUST
Gain an elementary understanding of Blockchain technology.
17

Expert Comment

by:sitg
Comment Utility
One of my friend having the following query

How is it different from a centralized server handling all transactions with encryption. Why the fuss in real world usage. Can you shed some light cos i never got the idea.
0
LVL 15

Author Comment

by:David L. Hansen
Comment Utility
sitg,

There are several differences between a centralized server (using encryption) and the blockchain process. Here are the two biggest differences though:

First: Multiple distributed servers. When there are many servers around the world who all have to agree to the transaction you're attempting to make, the difficulty in faking a bad record (or changing a good one) becomes far more difficult because you need to attack all the servers at the same time.

Second: Chained records. Even if you get lucky with the first step (attacking all servers) and make it into the records of all servers at the same time by using some amazing hacking tools, now you have to alter every record in the stack. You see, you can't just change one and be done. You have to alter each of the records because their signatures are derived from ALL the previous ones. It's like replacing a child in a family with some random person. It won't work because they need to look like their parents (and the parents need to look like the grandparents). The child is derived from the parents' DNA (or signature) and gets a new DNA which is easily distinguished as being in the family (or not, if it's being faked).

An interesting side-effect arises from those two features...Let's assume you pull off both of these really tough challenges. You are still not out of the woods. Let's keep with the analogy and say this particular blockchain is an Asian family. You successfully change them to Latino (along with inserting a fake, or altering an existing, child). All is well, you're in the clear, until someone takes out a family portrait which they took sometime ago (a backup of the blockchain - even an old one) and they say, "Wait, this family is supposed to be Asian. "Something is wrong here. "The family's been hacked!"
1
Hi,

I have been using Excel (Google Sheets) to manage my accounts / balance sheet for the last number of years.

- income with Tax breakdown on the left
- expenses with Tax breakdown on the right
- totals at the bottom

It works well for me, however I'm slightly concerned over how easy it is to update a cell in error with '10' vs '10000' without recognising it.

Can anyone recommend any software that provides the following:

- easy interface
- export for backup
- ability to duplicate line items (recurring expenses and income) so that when a recurring payment lands in my bank account, i can duplicate a previous record and update the date
- add note to each line item

Additional Benefits
- app
- receipt management

Thanks in advance for your help.
0
Do you all know of any cheap web based inventory programs out there.  It would need to be able to

Enter orders,part qty
Receive part , qty
Stock  into location
pick from location
reports
0
ON-DEMAND: 10 Easy Ways to Lose a Password
LVL 1
ON-DEMAND: 10 Easy Ways to Lose a Password

Learn about the methods that hackers use to lift real, working credentials from even the most security-savvy employees in this on-demand webinar. We cover the importance of multi-factor authentication and how these solutions can better protect your business!

hi experts,

 I have quicken 2016 and I'd like to email the year 2014 and 2015 to my accountant. How do I go about doing that? thanks.
0
We have a situation where a user-defined field has been added to the main Invoices table on a customer's Pastel Accounting system to store a VAT number. In certain situations the user has to enter that VAT number and if they do not then a trigger will come into operation to warn them by displaying a message. The problem arises when, after having shown the message, the user goes back to enter the value in the field but the system does not perform the update. I am showing below various versions of the trigger that we have tried to no avail.

 USE [Foodspec Co (Pty) Ltd]
GO
/****** Object:  Trigger [dbo].[tnt_VatNoPrommpt]    Script Date: 3/20/2017 2:26:00 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[tnt_VatNoPrommpt]
    ON [dbo].[InvNum]
    INSTEAD OF UPDATE
    AS
    BEGIN
            /*
                  ucIDSOrdInvCashSaleVATno UDF IS REQUIRED FOR THIS TO WORK!
                  FIELD NAME: InvCashSaleVATno
                  TYPE: STRING
                  SIZE: 100
                  CREATE ON:INVENTORY DOCUMENT - SALES ORDER
            */
            DECLARE @custID INTEGER
            DECLARE @vatNo VARCHAR(100)
            DECLARE @DocType INTEGER
            SELECT @custID = AccountId,
                     @DocType = DocType,
                     @vatNo = ISNULL(ucIDSOrdInvCashSaleVATno, '')
            FROM inserted
            IF @custID IN(36,37,1) AND @DocType = 4 AND @vatNo = ''
                  BEGIN;
                        --RAISERROR ('Please Supply A Cash Sale VAT Number!
                        
                        --                  This Transaction Will Be Rolled Back. '
                        --                  , 16, 1) WITH NOWAIT
                        --ROLLBACK TRANSACTION
                        THROW 50000, …
0
Due to an accounting error in my personal checkbook (which has been ongoing for over a year), I am finally attempting to find the error.  As such, I am using Lotus 1,2.3 to copy all entries in my check book ( in effect mirroring my check register) and then to proof it against my bank monthly statements.  In order to “speed up” the process, I have been using the @SUM button, which has functioned quite well until about half way through the entries.
In several instances there have been negative results so that the balance appears as ($xxx.xx). The second (payment/debit) entry, when attempting to subtract this from the above balance, results in a positive/added sum.  For the purpose of clarity, I have cut and pasted below that which  actually appears.

            Col. A                     Col..B        Col. C
                   ($9,241.33)
$600.00                   ($9,841.33)
            3440.07       ($6,401.26)
            2.13       ($6,399.13)
$125.00                   $6,399.13


Column A is the payment/debit amount.
Column B is the deposit/credit amount.
Column C is the balance amount.

My question is: By using the @sum button how can I obtain the correct balance amount (preferably with the parenthesis and dollar sign/$ ?

Second part of the question: Inasmuch as Col. A is entered and appears as a positive/+ amount, would it be best to have a minus sign (-) preceding the entered amount, or perhaps parenthesis?  If so, what would be the most simplistic way to include the sign on the several hundred entries (which I really would…
0

Accounting

Accounting measures and evaluates financial information for a business or an individual household, such as assets, liabilities, revenue, expenses, and more. Accounting professionals are often in charge of payroll, retirement plans, inspecting financial records, allocating resources, and ensuring the balance sheets of the organization are correct in order to properly inform business decisions.

Top Experts In
Accounting
<
Monthly
>