Recently getting back into PRC and purchased 2023. I noticed that my charitable contributions (Expenses->Charity) were never being picked up in the Taxes section of Tabular Projections (neither Summary, Taxes, or Itemized Deductions).
Looking back at entering the data, the First Year and Last Year columns for Scenario 1 show the wrong formatting. They show MM/DD/YYYY - so when I entered "2023", the values shown in the cells are "7/15/05". This is obviously incorrect, I wanted the donation for 2023, not 2005. I thought that meant PRC wanted the full MM/DD/YYYY format - so I changed "2023" to "01/01/2023" and "12/31/2023" for Start and End Dates, respectively. Once I got to the Tabular Projections to review the processing, the charitable contribution doesn't show up - it is "0" for 2023.
If I go back and enter "2023" and see the improperly formatted value "7/15/05", then the amounts show up properly in Tabular Projections.
Scenario 2 & 3 don't have this problem. If I Copy S1 when "2023" is entered, "2023" shows up for S2 & S3. If I enter the value "01/01/2023" in S1 and copy to S2 & S3, they show "44927". I doubt I will be alive in the year 44927 and PRC doesn't project my taxes out almost 43,000 years in the future. 🙂
I did not re-download, but worked from a fresh copy of my original download that had not been used yet. Are others seeing this as well?
- Ron
@pierce259 This is a quirk of Excel with no workarounds that I know of. The First Year and Last Year fields are formatted as General (i.e., no specific format) and the page is locked when you get the PRC file; however, if you type in a date, such as 7/15/05, Excel will change the formatting of the field to Date despite the fact that the page is locked. Unfortunately, I don't know of any fix for this issue. My only guidance would be to delete the contents of the corrupted fields (so that Excel's date code isn't carried forward), create a new export file, download a fresh copy of PRC (necessary to get rid of the corrupted format setting), then import the new export file and then enter the desired start/stop year (4-digit year only). That should eliminate the issue.
FYI, the 44927 value you're seeing in Excel's code for a specific date. That's how they maintain dates internally but it's normally converted to a human readable date before you see it.
Stuart
Hi Stuart,
I am very familiar with Excel, Dates, Formatting and Formulas. I know you have everything locked down, so assumed that you had a minor glitch in the formatting in the supplied SS. With the lockdown, I wouldn't expect the format to change from General to Date automatically. I went back to my original download and as long as I only enter a year, the General format stays and everything works properly. I did have to go into my last export and change the date and import, as the export had the MM/DD/YYYY format and the import crashes Excel when you try it - the spreadsheet actually exits. Anyway - I am back working fine. Thanks for the help and for creating PRC.
- Ron
