+ Reply to Thread
Results 1 to 6 of 6

Undoing pivot tables

Hybrid View

  1. #1
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Undoing pivot tables

    According to this site http://support.quickbooks.intuit.com...icles/HOW12247 QuickBooks will import Excel or Comma Separated Values (CSV) files. You can already import into Excel so you shouldn't have any problem importing that file into QuickBooks.

    When you are starting up in business, there is a lot to learn...software is just one part of it
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  2. #2
    Registered User
    Join Date
    12-19-2013
    Location
    New Braunfels
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Undoing pivot tables

    The problem I have with quickbooks at the moment is that the report in the example I uploaded is both a list of both income (sales) and expenses. From my very limited knowledge of quickbooks (just signed up 3 days ago) is that you have to separate them into one category or another. So my plan would be to organize the information via the pivot tables. Create two separate files and then upload them. And if that doesn't work, then just dump quickbooks and go back to my handy excel spreadsheet, this time with categorized expenses instead of the usual summary which is what I've been doing this past year.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating a Master / Consolidated Pivot Tables from a multiple pivot tables
    By paradise2sr in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-12-2013, 02:28 AM
  2. Creating a Master / Consolidated Pivot Tables from a multiple pivot tables
    By paradise2sr in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-08-2013, 10:49 PM
  3. Pivot Tables - need to do separate pivot tables for multiple sheets in same format
    By tconnell1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 07:04 AM
  4. Validating Data Between 2 Pivot Tables (Pivot Tables Don't Line Up)
    By JohnGC84 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-18-2013, 05:07 PM
  5. Replies: 0
    Last Post: 09-22-2012, 07:22 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1