Questions tagged [accounting]

Accounting is a function of an organization that produces financial records. These questions are related to utilizing software to complete accounting tasks

Filter by
Sorted by
Tagged with
16 votes
4 answers
4k views

How to move Mint transaction data to GnuCash

Online financial aggregators are great for getting transactions from all of your accounts into one place, but the accounting tools they provide are pretty minimal. I'm a Mint user, and I like the idea ...
i did not pay the royalties's user avatar
11 votes
2 answers
52k views

How do you reverse the sign of a range of numbers in Excel?

In accounting I sometimes download statements where although the transaction represents debit, the sign is negative. I then need to change the sign to be positive so it's actually indicating a true ...
deed02392's user avatar
  • 3,042
4 votes
4 answers
335 views

Is there an accounting or ERP package that runs on Windows, Linux, and Mac? [closed]

Is there an accounting or ERP package, either closed- or open-source, that has clients that run on Windows, Linux, and Mac? It does not matter if it is a free or paid solution. It must also be a "...
Avery Payne's user avatar
  • 2,501
4 votes
2 answers
4k views

Looking for a opensource, web based, double entry accounting system [closed]

I need some accounting functionality for an existing web based system and are trying to find an open source web based accounting package with which I can integrate instead of writing the functionality ...
Hannes de Jager's user avatar
3 votes
1 answer
274 views

Time and expense registration tracking tool [closed]

I am currently using a program named WorkBook - and am now looking for a cheaper replacement. Preferable free - open source software! I only use the time registration and expense registration parts ...
Rikke Holten's user avatar
2 votes
2 answers
14k views

How do I use Excel to categorize bank transactions into easily understandable categories to see where my money is going?

My boss wants our bank transactions categorized manually. Right now my task is to go through the bank transactions and categorize them into categories based on what each item is. For random ...
Pulse's user avatar
  • 311
2 votes
2 answers
51 views

What type of dataset am I working with here in Excel? What word or term can best describe it?

I am beginning to delve into data analysis via Excel and I would like to learn more about the terminology in terms of some data I'm playing with. I've created a sample data set for mock invoice ...
devindj6932's user avatar
2 votes
1 answer
198 views

Devising Excel Spreadsheet Formulas

I'm using Excel for the accounting purposes of a group venture, to keep track of our expenses, costs, payments, and balances. Details of each expense are stored in columns A:J Total costs and ...
oldboy's user avatar
  • 383
2 votes
1 answer
8k views

How to change default Accounting Number Format?

In most cases, the default accounting format in Excel is $ Without using some kind of macro Without changing timezone (or other system settings) of the computer How to change this and set another ...
Zameer Ansari's user avatar
2 votes
3 answers
1k views

Make gnucash to track something other than money

How to make gnucash track something other that national currencies and securities, for example, DVD-RW Discs, books and other things I can lend to people. I want to know who owes me some discs and ...
Vi.'s user avatar
  • 17.1k
2 votes
2 answers
144 views

Accounting software for a USA based small tech company [closed]

I just registered my .com business as an LLC. Which means I need to start paying taxes and do real accounting. I have an MSDN license so I have access to all Microsoft software. however it looks like ...
user25785's user avatar
1 vote
1 answer
7k views

How to make a graph of bank account data in excel with a table of balance changes?

I have an excel table with dates and according bank account balances. Now I add a graph and get the following: The graph should have a timeline on the x-axis - that works. But I want the data to be ...
Mathias Bader's user avatar
1 vote
1 answer
3k views

Data reconciliation with pivot table

I have 2 tables (table1, table2), each with 2 categorical variables/columns (product, country) and up to 5 real-valued variables to be reconciled/compared against each other (sales and other in the ...
user avatar
1 vote
1 answer
232 views

Multiple sales taxes in a sales receipt

I am using Quickbook online. I am trying to add multiple sales tax (Both state and county tax) in a sales receipt. But QBO only allows me to add only one tax. How can I add multiple tax rates in one ...
Neel's user avatar
  • 115
1 vote
2 answers
597 views

Excel Forecast model for subscriptions received in advance for next 2 years

I am working on a financial model that contains: Months in columns (Jan-2020 to Dec-2025) Number of subscribers per month (column) per package in rows Price of each package in rows Doing cash flow ...
Tee's user avatar
  • 33
1 vote
1 answer
318 views

Add Accounting Radius in the RAS (VPN) Configuration

I'm trying to create a powershell script for configuring a specific VPN remote access server in a Windows Server 2012-R2, the following command works fine but how can i configure accounting radius too?...
HBasiri's user avatar
  • 167
1 vote
1 answer
154 views

User Login/logout accounting to enforce max session time?

I'd like to set up a home system where users (i.e., house kids) have a given max time of computer use per day/week/whatever, and after that time they're logged off. They should be able to log in and ...
JJarava's user avatar
  • 433
1 vote
1 answer
536 views

The FINISH button on GnuCash Account Reconciliation is greyed out

This is my first attempt at using GnuCash to reconcile checking account. I've checked the transactions that appear on statement and the green check appears in the 'R' Column. According to GnuCash ...
zundarz's user avatar
  • 1,163
1 vote
1 answer
669 views

How can I modify tables and forms in a MS Access database using UA Business Software 7.0?

I need to make changes to table structures and forms on a MS Access database using UA Business Software 7.0 The problem is that UA hides everything and everything is locked.. It doesn't even look ...
Shawn's user avatar
  • 1,341
1 vote
0 answers
340 views

prerequisites before running sap business one

What processes should run on the background before I try to launch sap business one? I'm just a beginner and I need to create a new company before I can make use of sap. The problem is I can't create ...
Wern Ancheta's user avatar
  • 6,542
1 vote
2 answers
1k views

How can i send Automatic Invoices to my customers every month [closed]

I want to send my customers automatic invoice every month. Is there any online website which can do that. OR any plugin or script i can put on my own server to generate it Automatically
Mirage's user avatar
  • 3,183
1 vote
3 answers
971 views

Importing statements into Quickbooks

How do I import the following statements into Quickbooks Pro? Bank of America American Express
Raj More's user avatar
  • 931
0 votes
2 answers
777 views

Remember the Milk desktop alternative

I am looking for a simple software to track monthly expenses, jobs, etc which is as simple to use as Remember the Milk. I would like it to be offline, hence a desktop software. My operating system is ...
rzlines's user avatar
  • 7,538
0 votes
1 answer
28 views

EXCEL: What type of dataset am I working with overall? How to manipulate pivot tables to answer complex relationships between fields?

I am beginning to delve into data analysis via excel and I would like to learn more about the terminology in terms of some data I'm playing with. I've created a sample data set for mock invoice ...
devindj6932's user avatar
0 votes
1 answer
158 views

Unix accounting: lastcomm commands with no on-disk executables - what are they?

A security related exercise: For extra security, I have traditional Unix accounting (acct) turned on. This can help investigate suspicious activity after the fact. According to the man page /var/log/...
arielf's user avatar
  • 123
0 votes
1 answer
72 views

QuickBooks (Mac) Chart of Accounts has an empty column with a blue ball heading

QuickBooks 2014 (Mac) I'm simply looking for an explanation of an empty column in my Chart of Accounts. Its header is nothing but a blue ball. Hovering and clicking this column heading reveals ...
Sparky's user avatar
  • 211
0 votes
1 answer
225 views

Gnucash: how to breakdown assets by various accounts?

Suppose I have the following accounts in Gnucash: Assets Bank A Risky account, $1000 Non-risky account, $2000 Bank B Risky account, $5000 Non-risky account, $...
Dennis Golomazov's user avatar
0 votes
1 answer
192 views

Gamenet accounting

we have 5 systems and 5 XBOXs and we want to connecting these devices together for making a game net, I have used GamePort as accounting system, but one problem of this software is that we can join ...
Sirwan Afifi's user avatar
  • 1,562
0 votes
1 answer
3k views

How to install sap business one client [closed]

Please help, I need to install this software but there are some prerequisites that needs to be installed before I can install it. Problem is, I can't find download links for those. And it seems that ...
Wern Ancheta's user avatar
  • 6,542
0 votes
0 answers
22 views

TACACS+ accounting using linux client

Is it possible to log all commands executed in the Linux machine to a TACACS server?
Teresa's user avatar
  • 31
0 votes
0 answers
749 views

How to create a graph in Excel with cumulative changes without an accumulative sum chart

For three companies, I have an Excel export file from SAP which contains all bank transactions that occurred during 2021. Company A has 3 bank accounts, Company B has 2 and Company C has 1, so that's ...
Marc_123's user avatar
0 votes
1 answer
48 views

I'm having issue with counting with multiple criteria

Excel work screenshot: I need to count the amount of blank cells in "days utilized" judging by the year "2009" in "year started" row. The answer is 1, but I didn't get ...
Peacefulpeace's user avatar
0 votes
1 answer
358 views

IP Traffic accounting for OpenVPN users

I'm trying to find a way to do traffic accounting for OpenVPN to build graphs inside the webpage admin panel for OpenVPN. I have everything done. But I cannot get the IPTables to work correctly, I ...
geekism's user avatar
0 votes
1 answer
2k views

Adding Values of a specific label/tag in a spreadsheet

I am designing a spreadsheet for an accounting framework where I record all the transactions. Say there are 3 categories of transactions: A, B, C. I want to record the transaction, label my ...
Syed Husain's user avatar
0 votes
1 answer
492 views

Zentyal server + RSAT: create an administrator limited to a specific group of PCs

In my configuration I have a Zentyal 6 server that act as a PDC and 90 Windows client . I need to create a doman admin account that has right only to a specific group of PCs. Is it possibile to ...
Bau Miao's user avatar
  • 147
0 votes
1 answer
35 views

In Odoo 11, user with inventory management access have also accouting access

When I create a new user in Odoo 11 and I put "manager" in inventory section, the section "Accounting" gets automatically "Billing". The user works only in inventory, he doesn't need to see the ...
Wided Kéfi's user avatar
0 votes
0 answers
197 views

Data field not showing on invoice (QuickBooks 2013 R12)

My QuickBooks just updated to R12, and it seems that one of the data fields as inserted in the layout editor is not showing in on the final invoice, or the preview. It just leaves an empty space. The ...
Mike Rockétt's user avatar
-1 votes
2 answers
8k views

How to calculate revenue equally based on start and end dates?

My company phases revenue based on slightly obscure start/end dates and I need calculate how much revenue falls into the current year, based on these dates. If a contract starts on or after the 16th ...
Mikey Rowden's user avatar